| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching data from three columns (VLOOKUP, HLOOKUP, etc...)-URGENT
Hi All, Please help the due date is today (01/15) by the end of the day
I have series of data in excel spreadsheet (please see the below example) and have to complete the following: For each Application (A1)-Lookup by "Application Name" not by row#, I need to match Object (B1) and its Rating (C1) to update another worksheet. Application Object Rating db1 Instances/Subsystems 14 db1 Tables 4305 db1 Indexes 5940 db1 Procedures 1380 db1 Triggers 488 db1 Constraints 573 db1 # of rows 35 db64 Instances/Subsystems 1 db64 Tables 5383 db64 Indexes 4728 db64 Procedures 119 db64 Triggers 31 db64 Constraints 2173 db64 # of rows 150 db51 Instances/Subsystems 2 db51 Tables 230 db51 Indexes 498 db51 Procedures 142 db51 Triggers 0 db51 Constraints 230 db51 # of rows 00 Result: db1 Instances/Subsystems 14 Tables 4305 Indexes 5940 db64 Instances/Subsystems 1 Tables 5383 Indexes 4728 db51 Instances/Subsystems 2 Tables 230 Indexes 498 Thanks all in advance for fast reponses |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| matching 2 columns of data | Excel Discussion (Misc queries) | |||
| combined HLOOKUP (urgent for a friend) | Excel Worksheet Functions | |||
| Vlookup with non matching data | Excel Worksheet Functions | |||
| Matching Data in Columns | Excel Worksheet Functions | |||
| Matching data in columns | Excel Discussion (Misc queries) | |||
Threaded Mode
