In Sheet1,
In A2: =IF(A1="","",VLOOKUP(A1,Sheet2!A:B,2,0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Shek5150" wrote:
If I have two cells on Sheet 1 (cells A1 & A2) Where A1 is where Id enter
someones IQ score and A2 would represent their percentile rank. Sheet 2 is
a two column table w/ all possible IQ scores (Column A) and Percentile Ranks
(Column B).

My question, is it possible to use a lookup function to look up a percentile
rank (from sheet 2). For example, if I enter an IQ of 130 in cell A1 (sheet
1) and excel would look up the corresponding Percentile Rank (sheet 2) and
then bring this Percentile Rank value forward to sheet 1 and autopopulate
cell A2.