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!