One way............

=LOOKUP(J1&K1,{"","xg","xt"},{"","aaaaa","bbbbb"})

hth
Vaya con Dios,
Chuck, CABGx3



"Chuckee" wrote:

Hi,
Is it possible to nest if/and formulas or is there a different way to do it.
Here is my simple example

=IF(AND(J1="X", K1="G"), "AAAAA",""),IF(AND(J1="X", K1="T"),"BBBBB","")

Now this gives a #value! error

Any ideas?