I have a spreadsheet that in Column A has a department and column B has a
wage. I need to look up this wage in a national survey file, that will
return in column C the nat'l percentile, for that department. Is this
possible?

Column A Column B Column C
Acctg $95,243 65th percentile
Mrktg
Nursing

The problme I have ran into with my formula's, is that the survey file will
have of course a range of numbers, not my exact #. Therefore, my vlookup
formula is not working. How can I write a formula that would do this?

Thanks in advance.