If I understand you correction, you want to input a number in C1. Based on
the value in C1, you want a value to be placed in D1. The chart has numbers
in column A and names in column B.

If this is the case then place the following formula in D1:

=LOOKUP(C1,Chart!A1:A50,Chart!B1:B50)

This formula assumes the name of the worksheet the chart is on to be Chart
and that there are 50 rows of data. Adjust both accordingly.

Les




"Cateyes0122" wrote:

I am trying to figure out how to be able to enter a number from 1 to 43 (i.e.
C1 i type 10)in a column and have the formula in D1 with a condition if the
number in C1 matches the same number in a range name on a different sheet put
what is in the next cell (i.e. I have a chart on another sheet, so in A1 if
have the number 10 and in B1 I have the word "Sam" I want Sam to put put in
D1 where the formulas is ) This must be possible. Need major help