Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Cells (Read for more info) -- HELP PLEASE
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Cells (Read for more info) -- HELP PLEASE
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" wrote in message ... 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!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Cells (Read for more info) -- HELP PLEASE
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" wrote in message ... 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i add info to a read only excel document | New Users to Excel | |||
Read how to two-way link cells, now can't find the example!? | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
How do I read info from different worksheets into a summary sheet? | Excel Worksheet Functions | |||
i need info from the top workbook to be read in multiple workbooks | Excel Worksheet Functions |