auto fill from another sheet in excel
 

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
--
steve

auto fill from another sheet in excel
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"bluegrass" wrote in message
...
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
--
steve

auto fill from another sheet in excel
 

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$1 0,0))

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
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.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"bluegrass" wrote in message
...
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
--
steve