| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching multiple columns and retrieving a value
I'm trying to match multple colums in two sheets, then pull a rate from one
sheet into another. My source sheet looks like this: A B C D E Line Class Product Descr Rate ---- ----- --------- ----- ----- Term Report ATM LL .08 Term Report ATM DU .15 My second sheet will have the following: A B C D E Line Class Product Descr Rate ---- ----- --------- ----- ----- Term Report ATM LL Term Report ATM DU I need to pull the rate from sheet 1 into sheet 2. I have approx. 1,000 different combinations to sort through. Any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
| Retrieving non adjacent data from other workbooks? | Excel Worksheet Functions | |||
| retrieving values between 2 defined limits in experimetal data series | Excel Discussion (Misc queries) | |||
| Pivot table retrieving data from several worksheets | Excel Worksheet Functions | |||
Threaded Mode
