Combining one IF formula with a Vlookup Formula

[McNeil87]

Hello!

I'd like to try to combine/join these two formulas together to return TRUE or FALSE

First Formula: IF(F2="GB",TRUE,FALSE)
Second Formula: =IF(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),"FALSE","TRUE")

Essentially would like to say return True if the following condition is met: IF F2=GB and G2 is in the lookup list, then "True", otherwise if F2 <>GB and G2 is not in lookup list, then False.

Any suggestions is greatly appreciated!

Thank you!

 

[etaf]

ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE))
will give TRUE if G2 is not in the lookup list
F2 =GB will give TRUE

so combine then
AND ( ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)), F2 =GB )
should give a TRUE

BUT you dont need an IF

as
=AND ( ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)), F2 =GB )
will give a true or false result

hope thats what you want

 

[jdellasala]

I think this will work:

=IF(ISERROR(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),FALSE,TRUE)

Without an actual sample (posted using XL2BB), it's hard to say.

 

[McNeil87]

Thanks! I receive an #NAME Error:

=AND(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),F2=GB)

ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE))
will give TRUE if G2 is not in the lookup list
F2 =GB will give TRUE

so combine then
AND ( ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)), F2 =GB )
should give a TRUE

BUT you dont need an IF

as
=AND ( ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)), F2 =GB )
will give a true or false result

hope thats what you want

 

[Joe4]

=AND(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),F2=GB)

I think you need double-quotes around "GB":

=AND(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),F2="GB")

 

[McNeil87]

Thanks!

It's so close -- but i noticed it is returning TRUE for all of F2 that equals "GB."

I need it to return TRUE if F2="GB" AND Only return TRUE for F2 if G2 is a match against the lookup.

=AND(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),F2="GB")

 

[etaf]

=AND(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)),F2="GB")
change to
=AND(NOT(ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE))),F2="GB")

IF F2=GB and G2 is in the lookup list, then "True", otherwise if F2 <>GB and G2 is not in lookup list, then False.

 

[McNeil87]

That worked! Can you explain how the 'NOT' did that?

 

[etaf]

well, i misread the requirement .....

as i said

ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE))
will give TRUE if G2 is not in the lookup list

but you wanted

TRUE if G2 is in the lookup list,

so i just used a NOT() which reverses the Logic

so IF the result of ISNA(VLOOKUP(G2,UK!$M$2:$M$92,1,FALSE)) produces a TRUE - G2 is not in the lookup list , and you wanted that to be FALSE , then the NOT changes the TRUE to a FALSE