Vlookup issue

My vlookup skills have left me this evening...I know I'm close!

I've got a 5 column spreadsheet (example attached).

I'd like to compare the value in Column B with those in Column D and if there's a match, write the value from Column E into Column C.
- Narrative: If the value in B2 appears anywhere in the range D2:D7, write the company name in C2.
- Example: Value in B2 appears in D7, Name of company in E7 should be written in C2.

I'm using the following: =VLOOKUP(B2,$D$2:$D$7,5,FALSE) in Column C but keep getting #N/A or #REF.

Any help is appreciated!

In C2 put
=VLOOKUP(B2,$D$2:$E$7,2,FALSE)
and pull down.

You were close!!

Hi,

just change the third argument 5 into 2 in order to obtain correspondences from the second column of the range (D).

If you'd need, the following formula if does not find an exact match writes nothing instead of #N/A

Please Login or Register  to view this content.

Regards

How to mark a thread Solved
Go to the first post in this thread
Click Edit
Click Go Advanced
Just below the word Title you will see a drop-down with the word No prefix.
Change to Solved
Click Save