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.

"it seemed much more clear when it was just in my head..."

Thanks in advance.

Steve