| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or sum product
I have a work sheet (worksheet 1) that has three columns of data and I want
to match it against another worksheet (worksheet 2) that has those same three values in one column - if there is a match then i want to return a value in column J of worksheet 2. Worksheet 1: Column D = 00001 Column G = 00000123456 Column H= 000123 Column T = Want value from worksheet 2 column J if all three above match Worksheet 2: Column I = 0000100000123456000123 Column J = 98765 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Product Code and Product Description setup | Excel Worksheet Functions | |||
| I need a product key for my Trail product, 2007 Microsoft Office s | Setting up and Configuration of Excel | |||
| Using VLOOKUP to find product from 3 worksheets to put on one shee | Excel Worksheet Functions | |||
| Compare Old & New Product List (i.e. VLOOKUP) | Excel Worksheet Functions | |||
| VLOOKUP with PRODUCT functionality? | New Users to Excel | |||
Threaded Mode
