Try =IF(AND(ISNUMBER(B4),B44000), VLOOKUP(B4,table-ref,2), "S")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"jeremy via OfficeKB.com" wrote in message
...
This function works for me =IF(B44000, VLOOKUP(B4,Sheet1!#REF!,2), "S")

but I need to and an IF statment in front:

IF(B4=#,(function above), "S")

In other words, only if it is a number, if not a number, then "S".

--
Message posted via http://www.officekb.com