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

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

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

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

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

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:

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:

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:

Thanks for the feedback

"alex genadeloos" wrote in message
oups.com:

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