VLOOKUP to Display adjacent cell

[alex genadeloos]

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

 

[Stefi]

=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:

 

[JMay]

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]

JMay

Works like a charm!

Thx.

Alex

 

[alex genadeloos]

Stefi,

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

thx

Alex

 

[Stefi]

You are welcome! Thanks for the feedback!
As far as commas vs semicolons are concerned: common language of this forum
is English including Excel language version (except explicitely stated
otherwise). English uses commas as delimiters therefore all formulae posted
should use (and actually use) commas! I also use semicolons in my language
version but I always translate formulae to English version before posting.

Stefi

„alex genadeloos†ezt írta:

 

[JMay]

Thanks for the feedback

JMay

Works like a charm!

Thx.

Alex