Hi jeremy

Look in the help for the ISNUMBER worksheetfunction


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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