vlooup formula and if(),isna etc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,FALSE)),$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!
 
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
 
Yes! Thank you Pete_UK!

Pete_UK said:
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
Click to expand...
 
Back
Top