What problem are you having with your formula? Syntactically it's fine.

If you're copying the formula, you might need to convert the lookup
range to absolute:

=IF(B64000, VLOOKUP(B6,Sheet1!$A$1:$B$262,2,FALSE), "S")

In article ,
"jeremy via OfficeKB.com" wrote:

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