VLOOKUP to Display adjacent cell
 

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

VLOOKUP to Display adjacent cell
 

=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

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

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

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:

VLOOKUP to Display adjacent cell
 

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:

VLOOKUP to Display adjacent cell
 

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