=if(isnumber(b4),vlookup(....),"S")

"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