Nested formula

[Spraggs]

Hello all,
Is it possible to put the following in one formula?

=IF
Logical_test G2=""
Value_if_true ""
Value_if_false Concatenate the result of
=IF(ISNA(VLOOKUP(G2,$AE$3:$AF$10,2,FALSE)),"",VLOOKUP(G2,$AE$3:$AF$10,2,FALSE))
With cell F2

Regards Jase

 

[njimack]

=if(g2="","",if(countif($ae$3:$ae$10,g2),vlookup(g2,$ae$3:$af$10,2,false),""))

 

[Andrew Poulsom]

Try:

=IF(G2="","",IF(ISNA(VLOOKUP(G2,$AE$3:$AF$10,2,FALSE)),"",VLOOKUP(G2,$AE$3:$AF$10,2,FALSE)&F2))

 

[Jonmo1]

There should be no need to test if G2 is blank,
Because the Vlookup will be N/A if G2 is blank, and that's already tested for in the IF(ISNA formula

Try

=IF(ISNA(VLOOKUP(G2,$AE$3:$AF$10,2,FALSE)),"",VLOOKUP(G2,$AE$3:$AF$10,2,FALSE)&F2)

 

[Spraggs]

Thanks Guys