software

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

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

quot;bluegrassquot; gt; wrote in message
...
gt; I assign each person a number (this info is on another sheet in the same
gt; workbook) and would like this name to come up by typing in only the
number.
gt; thanks - just a part timer here lol
gt; --
gt; steveJust 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 !
---------------------------------------------------------------------------
quot;Ragdyerquot; gt; wrote in message
...
gt; If the datalist is on Sheet1 from A1 to B10, and the number is in Column
A,
gt; And the name is in Column B, you could use a Vlookup formula, such as:
gt;
gt; =VLOOKUP(D1,Sheet1!$A$1:$B$10,2,0)
gt;
gt; Where you enter the number to find into cell D1.
gt;
gt; However, if the data is reversed, with the names in Column A and the
numbers
gt; in Column B, you could try this formula:
gt;
gt; =INDEX(Sheet1!A1:A10,MATCH(D1,Sheet1!B1:B10,0))
gt;
gt; The second formula will work for the first scenario also.
gt; --
gt; HTH,
gt;
gt; RD
gt;
gt; --------------------------------------------------------------------------
-
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; --------------------------------------------------------------------------
-
gt;
gt; quot;bluegrassquot; gt; wrote in message
gt; ...
gt; gt; I assign each person a number (this info is on another sheet in the same
gt; gt; workbook) and would like this name to come up by typing in only the
gt; number.
gt; gt; thanks - just a part timer here lol
gt; gt; --
gt; gt; steve
gt;