I have a row ow project numbers, I want to assign those over a value of
4000 a function VLOOKUP(B6,Sheet1!A1:B262,2,FALSE) and all the prject
numbers that are not over 4000, assign the letter "S". Any help?

This is what I have....

=IF(B64000, VLOOKUP(B6,Sheet1!A1:B262,2,FALSE), "S")

Thanks...
Jeremy

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