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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup with corresponding two data (blank and non blnk)
Hi Rechie
The below formula would lookat Sheet2 ColA for the lookup value and return the non blank entry from Col B. Please note that this is an array formula. You create array formulas in the same way that you create other formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can notice the curly braces at both ends like "{=<formula}" =INDEX(Sheet2!$B$1:$B$100,MATCH(1,(Sheet2!$A$1:$A$ 100=lookup_value)* (Sheet2!$B$1:$B$100<""),0)) -- Jacob (MVP - Excel) "Rechie" wrote: 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 |
Reply |
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 |