Prev: Chart Goal Lines
Next: Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?
From: KeithD on 4 Apr 2010 01:20
Ok, this is for more advanced Excel users. Here's the issue.

Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
for a person, I want their name to automatically appear in COLUMN B from a
list in S2.

This is how S2's list is set up... A1 has a person's ID #, and B1 has that
same persons name. A2 has a different person's ID #, and B2 has that person's
name, etc... So when I type the ID # in S1 in column A, it will lookup in S2
and match that person's name with their ID.

I know this may be confusing, but I can't think of any way else to word it.
Any help will be very appreciated. Looking forward to your comments. Thank
you!!
From: ozgrid.com on 4 Apr 2010 01:25
VLOOKUP or INDEX/MATCH combo should do it;
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm


--
Regards
Dave Hawley
www.ozgrid.com
"KeithD" <KeithD(a)discussions.microsoft.com> wrote in message
news:221CE797-FB66-494B-8E38-E2F33FAE61D1(a)microsoft.com...
> Ok, this is for more advanced Excel users. Here's the issue.
>
> Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
> S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
> for a person, I want their name to automatically appear in COLUMN B from a
> list in S2.
>
> This is how S2's list is set up... A1 has a person's ID #, and B1 has that
> same persons name. A2 has a different person's ID #, and B2 has that
> person's
> name, etc... So when I type the ID # in S1 in column A, it will lookup in
> S2
> and match that person's name with their ID.
>
> I know this may be confusing, but I can't think of any way else to word
> it.
> Any help will be very appreciated. Looking forward to your comments. Thank
> you!!

From: KeithD on 4 Apr 2010 01:41
Thank you so much... The vlookup worked for me.

"ozgrid.com" wrote:

> VLOOKUP or INDEX/MATCH combo should do it;
> http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
> http://www.ozgrid.com/Excel/left-lookup.htm
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "KeithD" <KeithD(a)discussions.microsoft.com> wrote in message
> news:221CE797-FB66-494B-8E38-E2F33FAE61D1(a)microsoft.com...
> > Ok, this is for more advanced Excel users. Here's the issue.
> >
> > Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
> > S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
> > for a person, I want their name to automatically appear in COLUMN B from a
> > list in S2.
> >
> > This is how S2's list is set up... A1 has a person's ID #, and B1 has that
> > same persons name. A2 has a different person's ID #, and B2 has that
> > person's
> > name, etc... So when I type the ID # in S1 in column A, it will lookup in
> > S2
> > and match that person's name with their ID.
> >
> > I know this may be confusing, but I can't think of any way else to word
> > it.
> > Any help will be very appreciated. Looking forward to your comments. Thank
> > you!!
>
 | 
Pages: 1
Prev: Chart Goal Lines
Next: Using Picasso Photo Viewer to Open Excel Hyperlink in MS 2007?