VLOOKUP to Display adjacent cell
You could Expand your range to be $O$1:$P$202 and use:
=IF(VLOOKUP(A5;$O$1:$P$202;1)=A5; VLOOKUP(A5;$O$1:$P$202;2);"NOK")
HTH
"alex genadeloos" wrote in message
oups.com:
Excel Wizzes,
How do I get VLOOKUP to display the value of a cell that is adjacent to
the cell that has the result that i am vlooking for? (riiiight, I don't
think anyone knows what I mean...)
What I mean is: here's my vlookup formula
=IF(VLOOKUP(A5;$O$1:$O$202;1)=A5;"OK";"NOK")
Where it displays OK if it finds the content of A5 in the O column I
want it to display the cell next to that cell, on the same row in the
next column. So if it finds A5 in O20 I want the formula to display P20
instead of OK.
Anybody any experience or tips how to do this?
Thx
Alex
|