auto fill from another sheet in excel

B

bluegrass

I assign each person a number (this info is on another sheet in the same
workbook) and would like this name to come up by typing in only the number.
thanks - just a part timer here lol
 
R

Ragdyer

If the datalist is on Sheet1 from A1 to B10, and the number is in Column A,
And the name is in Column B, you could use a Vlookup formula, such as:

=VLOOKUP(D1,Sheet1!$A$1:$B$10,2,0)

Where you enter the number to find into cell D1.

However, if the data is reversed, with the names in Column A and the numbers
in Column B, you could try this formula:

=INDEX(Sheet1!A1:A10,MATCH(D1,Sheet1!B1:B10,0))

The second formula will work for the first scenario also.
 
R

Ragdyer

Just in case you're copying down, forgot to add the absolutes to the second
formula ranges:

=INDEX(Sheet1!$A$1:$A$10,MATCH(D1,Sheet1!$B$1:$B$10,0))
 
Top