Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a function for "not isblank" (find a cell that has a val.
I am searching across 5 cells.
One of the 5 will have a value in it. Depending upon which cell has a value on it I will preform a lookup. If the value isblank I do not want to perform the lookup. How can I have multiple nested if statements while using the lookup. |
#2
|
|||
|
|||
Hi Jim
if the lookup is depended on which cell has the value in it then you need to check each cell e.g. =IF(ISBLANK(A1),IF(ISBLANK(A2),IF(ISBLANK(A3),IF(I SBLANK(A4),IF(ISBLANK(A5),"",your_lookup_formula_f or_A5),your_lookup_formula_for_A4),your_lookup_for mula_for_A3),your_lookup_formula_for_A2),your_look up_formula_for_A1) Cheers JulieD "Jim" wrote in message ... I am searching across 5 cells. One of the 5 will have a value in it. Depending upon which cell has a value on it I will preform a lookup. If the value isblank I do not want to perform the lookup. How can I have multiple nested if statements while using the lookup. |
#3
|
|||
|
|||
Hi Jim.........
If you are sure there will only be a value in one of the cells, you can name the range of those cells "RANGE1" or whatever, and your VLOOKUP table "Range2" or whatever, and use this formula......... =VLOOKUP(SUM(range1),range2,2,FALSE) Vaya con Dios, Chuck, CABGx3 "Jim" wrote in message ... I am searching across 5 cells. One of the 5 will have a value in it. Depending upon which cell has a value on it I will preform a lookup. If the value isblank I do not want to perform the lookup. How can I have multiple nested if statements while using the lookup. |
#4
|
|||
|
|||
Hi
if you could explain which lookups you want to do depending on what cells there may be an easier solution. Could you state exactly your conditions and lookup requirements (with exact cell references) -- Regards Frank Kabel Frankfurt, Germany "Jim" schrieb im Newsbeitrag ... I am searching across 5 cells. One of the 5 will have a value in it. Depending upon which cell has a value on it I will preform a lookup. If the value isblank I do not want to perform the lookup. How can I have multiple nested if statements while using the lookup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
ISNULL function - can't find it | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Function to return colour of formatted cell | Excel Worksheet Functions |