Hi,
Which is the criteria to select 10th in the case you enter a salary of 33000
and no 11th from column D since the salary there is 33456

"Sr Accountant" wrote:

I am wanting to pull the percentile that my wage falls into. Here is an
example of my survey file.

Col A = Depart Col B= Median % Col C = 10th %tile Col D =11th
%tile....Etc....
Accounting $64,987 $32,765 $33,456

Does this help? I am not sure how to write a forumla to look for the
department name and then the range of what my wage is. I do not need the
median %, I am truly looking for the %tile. If my wages were $33,000 for
Acctg, I would want the formula to return 10th %tile.

Thank you.



"Eduardo" wrote:

Hi,
when you said national survey do you want to pull an average, could you send
an example of your survey

"Sr Accountant" wrote:

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.