| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple criteria search
Hi All
How do I include Four criteria cells to determine the row and one criteria cell to determine the COLUMN to find a specific cell value? e.g Sheet One (the criteria & the formula) A B C D E F G R10 Jan Feb Mar R11 R12 R13 R14 R15 18-24 R16 R17 SYD 45 XXX XXX Criteria: $A17 = SYD $B17 = 45 $C$15 = 18-24 E$10 = Jan Sheet Two (the data to search through and match the criteria too) A B C D E F R3 Place Size Age Jan Feb Mar R4 SYD 60 18-24 100 80 60 R5 SYD 45 18-24 50 75 55 R6 SYD 60 25-54 101 81 61 R7 SYD 45 25-54 51 76 55 ETC The formula needs to go to Sheet Two (A4:AE360) and match to a row that includes: "45" in column A "SYD" in Column B, "18-24" in Column C and then go to the Jan Column and report the intersecting price = 50 Any help would be greatly appreciated. -- Thanks BeSmart |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum on multiple columns with search criteria | Excel Worksheet Functions | |||
| Multiple search criteria | Excel Worksheet Functions | |||
| Search for multiple criteria, and return yet another | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Search string with multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
