Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Need to link data in Excel ..help!?

Ok, Basically in one column I have the name of a business, and the next column the mileage to go to that business. I'd like to be able to type in a business name in column A and have column B automatically fill in the same information for that business each time. Does this make sense?

Every time I put in Business A i want it to say 2.22

everytime I put in Business B i want it to say 3.33 or something to that extent

Update:

ok i pretty much know nothing about excel, just some basic stuff i taught myself so all those ratio looking numbers are very confusing to me!@

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    The easiest way is to use a VLookup formula. Somewhere in your worksheet, say in columns AA-AB, enter your company names and mileages associated with each company. Assuming you have 5 companies, the data would be in AA1:AB5. You can hide those columns if you choose.

    Then in column B1, enter the formula

    = If(A1 = "", "",VLookup (A1,$AA$1:$AB$5,2,False))

    Copy the formula 5 rows down column B.

    Enter a company name in column A1 to A5, and the associated mileage will appear in column B.

    Adjust your ranges and number of rows to enter the formula to suit your needs.

Still have questions? Get your answers by asking now.