| 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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlooup formula and if(),isna etc
You could try this:
=IF(OR(VLOOKUP($C27,'sheet1'!$A$4:$AH $1000,23,FALSE)="",ISNA(VLOOKUP($C27,'sheet1'!$A$4 :$AH $1000,23,FALSE))),$I28,(VLOOKUP($C27,*'sheet1'!$A$ 4:$AH $1000,23,FALSE))) Hope this helps, Pete On May 29, 10:30 am, Claudia wrote: 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,2 3,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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlooup formula and if(),isna etc
Yes! Thank you Pete_UK!
"Pete_UK" wrote: You could try this: =IF(OR(VLOOKUP($C27,'sheet1'!$A$4:$AH $1000,23,FALSE)="",ISNA(VLOOKUP($C27,'sheet1'!$A$4 :$AH $1000,23,FALSE))),$I28,(VLOOKUP($C27,Â*'sheet1'!$A $4:$AH $1000,23,FALSE))) Hope this helps, Pete On May 29, 10:30 am, Claudia wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlooup formula and if(),isna etc
You're welcome, Claudia - thanks for feeding back.
Pete On May 29, 1:02 pm, Claudia wrote: Yes! Thank you Pete_UK! "Pete_UK" wrote: You could try this: =IF(OR(VLOOKUP($C27,'sheet1'!$A$4:$AH $1000,23,FALSE)="",ISNA(VLOOKUP($C27,'sheet1'!$A$4 :$AH $1000,23,FALSE))),$I28,(VLOOKUP($C27,*'sheet1'!$A$ 4:$AH $1000,23,FALSE))) Hope this helps, Pete On May 29, 10:30 am, Claudia wrote: 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!- Hide quoted text - - Show quoted text - |
| Reply |
| 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 | |||
Linear Mode
