Is it IF or vlookup or both?

Originally Posted by ChemistB

Yes, that formula works on a range basis. If you put any value between 0 and 30,000 into C2, D2 will return 0. If you put any value between 30,001 and 60,000, D2 will return 30,001 and so on. What do you need that is not covered by that?

I don't think it works because the what is my cell is:
under $30,000 or $30,000 - $60,001 or the others... the cells contains the $ signs and the commas and dashes.

i did try your formula and it didn't work.