Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
display the cell value in the next 33rd cell | Excel Worksheet Functions | |||
how do i use 'if' command to display answer in different cell? | Excel Discussion (Misc queries) | |||
Display adjacent cell as result... | Excel Discussion (Misc queries) | |||
Vlookup for data contained in a cell | Excel Worksheet Functions | |||
VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions |