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
|