Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with corresponding two data (blank and non blnk)
Hi Experts,
How can I get the results of vlookup where there are two corrsponding data in other sheet. One is blank and the other is non blank. I want to get the results of non blank cell and ignore the blank one. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Vlookup Displays Blank | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
VLOOKUP if a Cell is not Blank | Excel Worksheet Functions |