View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shek5150 Shek5150 is offline
external usenet poster
 
Posts: 14
Default Auto fill cell based upon another cell value

Thanks in advance for your help.

I'd like to be able to do the following:

Cell A1 would received a value (manually entered) of 1-19 and base upon that
value... cell B1 would yield a corresponding percentile.

For example:

If the user were to enter a scaled score of 9 (into cell A1) then the
percentile 37% would be autofilled in cell B1.

note: I have 19 scaled scores that have corresponding percentiles...I've
tried to copy (and alter) a code that I thougt would work...but it went kaput.

Again, thanks in advance for any help w/ this issue.

Steve