| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlooup formula and if(),isna etc
Hello,
I would like to derive the formula that if vlookup is #NA or is ="", then it provides the value that is in a row above. Right now, I have: =IF(ISNA(VLOOKUP($C27,'sheet1'!$A$4:$AH$1000,23,FA LSE)),$I28,(VLOOKUP($C27,'sheet1'!$A$4:$AH$1000,23 ,FALSE))) But I do not know how to modify it to include the case, when vlookup value is = "" Can anyone help? Thank uou in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking cells (VLOOUP/IF function maybe?) | Setting up and Configuration of Excel | |||
| Using ISNA with OR | Excel Worksheet Functions | |||
| challenge! ISNA() and complex array formula | Excel Discussion (Misc queries) | |||
| How do I use ISNA on this formula | Excel Worksheet Functions | |||
| IF(ISNA formula problem | Excel Worksheet Functions | |||
Threaded Mode
