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!