Thread: VLOOKUP to Display adjacent cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
alex genadeloos alex genadeloos is offline
external usenet poster
  
Posts: 3
Default VLOOKUP to Display adjacent cell
JMay

Works like a charm!

Thx.

Alex

JMay wrote:
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

Reply With QuoteReply With Quote