Multiple If Then Vlookups.

I want to combine the following into one statement,

=IF(ISNA(VLOOKUP($A2,'WTD'!$A$2:$F$5,5,FALSE)),H2,ROUND(H2*0.25,2))

And

=IF(ISNA(VLOOKUP($A2,'WTR'!$A$2:$F$10,5,FALSE)),H2,ROUND(H2*0.1,2))


Basically, do both of those functions, since there drawing from 2 different sheets.

How to combine?

Thanks

you cannot.

you are stating that if something is false, do 1 thing or return another.

Then you test if something else is false do the same one thing but if not return yet another value


=if(a=3,99,88)
=if(a=5,99,77)

can you see why these 2 cannot be combined?

At present you have only asked why something does not work.

If you specify what you want to achieve, someone may come up with a solution.

As Robert says, you currently have two possible outcomes for the same condition.

Ideally, post a copy of your sheet with the explanatrion of the desired outcome.

Ed

Hi

How about

=IF(AND(ISNA(VLOOKUP($A2,wtd!$A$2:$F$5,5,FALSE)),ISNA(VLOOKUP($A2,wtr!$A$2:$F$10,5,FALSE))),H2,IF(AND(NOT(ISNA(VLOOKUP($A2,wtd!$A$2:$F$5,5,FALSE))),ISNA(VLOOKUP($A2,wtr!$A$2:$F$10,5,FALSE))),ROUND(H2*0.25,2),ROUND(H2*0.1,2)))

You don't give any precedence to determine which output you want if both vlookup formulas would return a valid result. If this one isn't correct, then swap the 2 round formulas to return the opposite result.

If you want something else entirely when both would return a valid result, then you will have to nominate.


HTH

rylo