Prev: How do I recover a forgotten password?
Next: where text wraps in a cell, how can the row height be auto set
From: jacki on 14 Apr 2010 18:31
What is the best way to be able to enter a number into a cell and it returns
the name that corresponds with that number in the cell to the right of it.
The numbers and names to view from would be on a master/seperate worksheet.

Thanks so much for your help.
From: Don Guillett on 14 Apr 2010 18:44
Look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"jacki" <jacki(a)discussions.microsoft.com> wrote in message
news:1675AFF2-5950-4D5A-B1E0-C66FA0090E64(a)microsoft.com...
> What is the best way to be able to enter a number into a cell and it
> returns
> the name that corresponds with that number in the cell to the right of it.
> The numbers and names to view from would be on a master/seperate
> worksheet.
>
> Thanks so much for your help.

From: Max on 14 Apr 2010 18:52
Index/match gives you the versatility to return any col to the left or right
of the match col

Eg in Sheet2,
You could have something like this in say, C2:
=INDEX(Sheet1!A:A,MATCH($B2,Sheet1!$B:$B,0))
to return Sheet1's col A based on exact matching B2 within Sheet1's col B

The col to return is specified in this part:
INDEX(Sheet1!A:A

Inspiring? hit the YES below
--
Max
Singapore
---
"jacki" wrote:
> What is the best way to be able to enter a number into a cell and it returns
> the name that corresponds with that number in the cell to the right of it.
> The numbers and names to view from would be on a master/seperate worksheet.
>
> Thanks so much for your help.
From: jacki on 14 Apr 2010 19:20
Thanks so much for the quick reply but I guess I'm just dense.

I need to type a number in sheet 1, a2.. It will go to sheet 2 and match
that number with all the numbers in column a and copy the name next to that
number back to sheet 1,b2. I hope this makes sense as it's been awhile since
I have used Excel.

Thanks again for your time and help.

"Max" wrote:

> Index/match gives you the versatility to return any col to the left or right
> of the match col
>
> Eg in Sheet2,
> You could have something like this in say, C2:
> =INDEX(Sheet1!A:A,MATCH($B2,Sheet1!$B:$B,0))
> to return Sheet1's col A based on exact matching B2 within Sheet1's col B
>
> The col to return is specified in this part:
> INDEX(Sheet1!A:A
>
> Inspiring? hit the YES below
> --
> Max
> Singapore
> ---
> "jacki" wrote:
> > What is the best way to be able to enter a number into a cell and it returns
> > the name that corresponds with that number in the cell to the right of it.
> > The numbers and names to view from would be on a master/seperate worksheet.
> >
> > Thanks so much for your help.
From: Don Guillett on 14 Apr 2010 19:43
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"jacki" <jacki(a)discussions.microsoft.com> wrote in message
news:582DC21E-9A5E-4992-8B09-FE6B0CFCFE9E(a)microsoft.com...
> Thanks so much for the quick reply but I guess I'm just dense.
>
> I need to type a number in sheet 1, a2.. It will go to sheet 2 and match
> that number with all the numbers in column a and copy the name next to
> that
> number back to sheet 1,b2. I hope this makes sense as it's been awhile
> since
> I have used Excel.
>
> Thanks again for your time and help.
>
> "Max" wrote:
>
>> Index/match gives you the versatility to return any col to the left or
>> right
>> of the match col
>>
>> Eg in Sheet2,
>> You could have something like this in say, C2:
>> =INDEX(Sheet1!A:A,MATCH($B2,Sheet1!$B:$B,0))
>> to return Sheet1's col A based on exact matching B2 within Sheet1's col B
>>
>> The col to return is specified in this part:
>> INDEX(Sheet1!A:A
>>
>> Inspiring? hit the YES below
>> --
>> Max
>> Singapore
>> ---
>> "jacki" wrote:
>> > What is the best way to be able to enter a number into a cell and it
>> > returns
>> > the name that corresponds with that number in the cell to the right of
>> > it.
>> > The numbers and names to view from would be on a master/seperate
>> > worksheet.
>> >
>> > Thanks so much for your help.

 |  Next  |  Last
Pages: 1 2
Prev: How do I recover a forgotten password?
Next: where text wraps in a cell, how can the row height be auto set