Check out my "other" post.......it effectively does just that........try
it.........it will return either BB or AZ depending onthe value in AZ, just
as your IF formula specifies.
**********************************************
Just use a normal VLOOKUP, like this
=VLOOKUP(B1,FAST,2,FALSE)
Then, in the FAST table, in the cell just to the right of the value found in
B1, put your IF formula........
=IF(AZ=0,BB,AZ)
************************************************** *

Vaya con Dios,
Chuck, CABGx3





"George" wrote:

I need the If Statement to be inside the VLOOKUP. Is this possible.

"CLR" wrote:

Is this something like what you're looking for?

=IF(A1=1998,VLOOKUP(A1,YourLookupTableA,2,False),V LOOKUP(A1,YourLookupTableB,2,False)

Vaya con Dios,
Chuck, CABGx3



"George" wrote:

Is there any way to combine the VLOOKUP and IF Statement formula's into one
formula or is there any other kind of formula which does both????