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!

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!

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!

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 -