Combining If, And, Isnumber and 2 vlookups

[ryland00]

Hello,

I am trying to figure out how to do this and I am sure it's probably an easy fix but I have two formulas...

=IF(AND(ISNUMBER($I2),VLOOKUP($P:$P,Key!AD:AE,2,0)="Yes"),"Yes","No")

=VLOOKUP($P2&$I2,Key!Z:AA,2,0)

The first formula is saying that if the value in i2 is a number AND when the vlookup returns with a value of "Yes", then say "Yes", else "No"

The second formula is just a standard vlookup checking two values combined against a key where I have a set of values to check against.

I am just trying to combine the two so that instead of "No" in the first formula, I could put the vlookup there... Like using an IFERROR... But I just can't seem to figure out how to make it work. The values that don't meet the first two criteria just result in an NA.

Any help is greatly appreciated!

Ryan

 

[ryland00]

=VLOOKUP($P2&$I2,Key!Z:AA,2,0) = N/A

cell P1 = $P2&$I2

=VLOOKUP(P1,Key!Z:AA,2,0) = Answer

-HTH

Unfortunately, this did not work.

Appreciate your help!

 

[ryland00]

Unfortunately, this did not work.

Appreciate your help!

Well,

I changed the formula to the following and it now returns "TRUE" for all of the lines, so I guess I "figured it out". Hopefully, although I wasn't very descriptive, this will help some lost soul in the future!

=IFERROR(AND(ISNUMBER($I3),VLOOKUP($P3,Key!AD:AE,2,0)="Yes"),VLOOKUP($P3&$I3,Key!Z:AA,2,0)="yes")

Ryan