Vlookup formula to loop between numbers in a coloumn

[mmlabanca]

Hi,
I am working on a formula for which I think I might need a macros. I have a vlookup formula that looks up a value in column D, and matches the returned value (column E) with column B. If there is a match, the value in column C is returned. However, the vlookup needs to be applied to several values, and if I write every value down manually, the formula will be extremely lengthy.

Here is a sample of the formula for just 2 values in column A:

=IF(VLOOKUP(1,$D$2:$E$144,2,FALSE)=B2,C,IF(VLOOKUP(2,$D$2:$E$144,2,FALSE)=B2,C2,""))

Instead of having lookup_values of 1, 2, etc in the vlookup formula... I want it to refer to column D's values (1 to 144)...

I am not sure how to do this... The "IF" statement would be really lengthy if I continue with lookups for values 1-144...

Thank you very much for any guidance you could give me.

Mercedes

 

[Rijnsent]

Hi Mercedes,

so basically you're trying to look up the values of B2 in column E, right? Why don't you put your "found values (C and C2 in your example formula) in column F and make a simple VLOOKUP with columns E and F?

=VLOOKUP(B2,$E$2:$F$144,2,FALSE)

Ciao,

Koen