Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Match
I have a worksheet where I need to populate column J 'Aug Totals" with
information from another worksheet using the Title as the cross reference. Neither worksheet is sorted and the columns are not in the same order. It would also be nice to have a '0" populate if a match is not found. Worksheet 1 Column A ..... Column I Column J TITLE July Total August Total NV18210 RSD1235-SR-202-AF D4320C00006 3200A3-2201-US 905-CL-058 Worksheet 2 Column D Column E Column F TITLE Customer August Total A0221005 12,567 MEA20191 2,345 NV18210 29,912 Nasonex - P05583 27,223 5892C00015 3,258 905-CL-058 2,151 A7471004 2,015 QEDI ZHA33864 11915A 1,884 Desired result Worksheet 1 Column A ..... Column I Column J TITLE July Total August Total NV18210 29,912 RSD1235-SR-202-AF 0 D4320C00006 0 3200A3-2201-US 0 905-CL-058 2,151 Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index Match
Sharon,
This should help, place this formula in the Column J which you would like to lookup (amend as necessary): =IF(ISERROR(VLOOKUP(A2,<WorkSheet1!D:F,3,FALSE)), 0,VLOOKUP(A5,<WorkSheet1!D:F,3,FALSE)) Replace <WorkSheet1 with your Tabs/Sheets. -- --Thomas [PBD] Working hard to make working easy. "Sharon C" wrote: I have a worksheet where I need to populate column J 'Aug Totals" with information from another worksheet using the Title as the cross reference. Neither worksheet is sorted and the columns are not in the same order. It would also be nice to have a '0" populate if a match is not found. Worksheet 1 Column A ..... Column I Column J TITLE July Total August Total NV18210 RSD1235-SR-202-AF D4320C00006 3200A3-2201-US 905-CL-058 Worksheet 2 Column D Column E Column F TITLE Customer August Total A0221005 12,567 MEA20191 2,345 NV18210 29,912 Nasonex - P05583 27,223 5892C00015 3,258 905-CL-058 2,151 A7471004 2,015 QEDI ZHA33864 11915A 1,884 Desired result Worksheet 1 Column A ..... Column I Column J TITLE July Total August Total NV18210 29,912 RSD1235-SR-202-AF 0 D4320C00006 0 3200A3-2201-US 0 905-CL-058 2,151 Thanks |
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 |