| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
