View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 422
Default 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