Thread: VLOOKUP to Display adjacent cell
View Single Post
  #5   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
Stefi,

A few comma's for semicolon's aside this works super as wel!

thx

Alex

Stefi wrote:
=IF(ISERROR(VLOOKUP(A3,$O$1:$P$202,2,FALSE)),"NOK" ,VLOOKUP(A3,$O$1:$P$202,2,FALSE))

Regards,
Stefi

,,alex genadeloos" ezt írta:


Reply With QuoteReply With Quote