putting a description in adjecent cell in excel (using functions in excel)

david stein
david stein used Ask the Experts™
on
I have a list of websites in excel row next to each website in the adjacent cell I have the website location ie (a1 is website name -newyorkgrocery.com and b1 is the location-new york)
I have another list that contains one row with multiple of the same websites.
How do I set up function where if the value of the cell in the new row (row c equals to a value in a cell in row a then it will copy the location listed next to a and put it in row d
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You can use a vlookup like this, In D1 type:

=vlookup(C1, A:B, 2, FALSE)

drag the formula down column D
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial