vlooup formula and if(),isna etc

C

Claudia

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!
 
P

Pete_UK

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
 
C

Claudia

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching the formula (not the value) for a text string 1
ISNA Formula returning "False" instead of value 4
IF, ISNA & VLOOKUP 5
=IF(NOT(ISNA(VLOOKUP Function 2
summing results of multiple vloopups 1
vlookup returning Errors (ISNA formula) 3
VLOOKUP & Data Validation 0
I need help with a IF(ISNA with vlookup 5

Top