Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index, Match Help
Here is the situation:
I have two worksheets. Sheet1 has a list of user names in colA Sheet2 has a list of user names in colA, with the corresponding Person in colB. How can I have it match the user names up and then return the corresponding person name to sheet 1, so that it will also list the persons name, not just the username. Hope I am making sense. SHEET1 A1: PTJSM A2: PTZDP A3: PTHLC A4: PTPDJ SHEET2 A1: PTPDJ B1:Paul Jones A2: PTHLC B2: Harrie Carry A3: PTJSM B3: Jimmie Maxwell A4: PTZDP B4: Zach Pox Also, I would like for it to return nothing, just be blank, if their is no corresponding match. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index, Match Help
=VLOOKUP(Sheet1!A2,SHeet2!A:B,2,False)
-- __________________________________ HTH Bob wrote in message ... Here is the situation: I have two worksheets. Sheet1 has a list of user names in colA Sheet2 has a list of user names in colA, with the corresponding Person in colB. How can I have it match the user names up and then return the corresponding person name to sheet 1, so that it will also list the persons name, not just the username. Hope I am making sense. SHEET1 A1: PTJSM A2: PTZDP A3: PTHLC A4: PTPDJ SHEET2 A1: PTPDJ B1:Paul Jones A2: PTHLC B2: Harrie Carry A3: PTJSM B3: Jimmie Maxwell A4: PTZDP B4: Zach Pox Also, I would like for it to return nothing, just be blank, if their is no corresponding match. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Index, Match Help
On Apr 24, 12:12*pm, "Bob Phillips" wrote:
=VLOOKUP(Sheet1!A2,SHeet2!A:B,2,False) -- __________________________________ HTH Bob wrote in message ... Here is the situation: I have two worksheets. Sheet1 has a list of user names in colA Sheet2 has a list of user names in colA, with the corresponding Person in colB. How can I have it match the user names up and then return the corresponding person name to sheet 1, so that it will also list the persons name, not just the username. Hope I am making sense. SHEET1 A1: PTJSM A2: PTZDP A3: PTHLC A4: PTPDJ That did it! Thanks a bunch. SHEET2 A1: PTPDJ B1:Paul Jones A2: PTHLC B2: Harrie Carry A3: PTJSM B3: Jimmie Maxwell A4: PTZDP B4: Zach Pox Also, I would like for it to return nothing, just be blank, if their is no corresponding match. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |