IF statment/function

[jeremy via OfficeKB.com]

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(B6>4000, VLOOKUP(B6,Sheet1!A1:B262,2,FALSE), "S")

Thanks...
Jeremy

 

[JE McGimpsey]

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(B6>4000, VLOOKUP(B6,Sheet1!$A$1:$B$262,2,FALSE), "S")

 

[jeremy via OfficeKB.com]

Sorry, I didn't specify that: I want all the project number under 4000 to
be assigned the category "S", which would be ok but some of them have
letters at the beginning or end (eg. "AD0023" or "4100WH")....

I just thought that maybe I can use paste/special first....

 

[jeremy via OfficeKB.com]

I tried paste special--it doesn't seem to get rid of the letters in front
or behing a number....