Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What's the best way to return a specified cell value from a separate
tab/sheet, using multiple criteria, and without sorting the source data/table (see below example)? Tab 1 / Sheet 1 - Input Data B2:B10 Division Values - Division 1, Division 2, or Division 3 C2:C10 Category Values - Revenue, Expenses, Profit D2:O10 Amounts - Monthly amounts for each B2:B10 Divisions and B2:B10 Categories Tabs 2, 3 and 4 - Extracted Lookup and Display Data In 3 separate sheets/tabs dedicated to each Division, I want to display, in Cells C1 through N3, the monthly Amounts (i.e. the appropriate row of monthly amounts) from Tab 1 based on the the Divisions entered in Cell A1 of Tabs 2-4 (e.g. Tab1, Cell A1 = Division 1), and the Categories entered in Cells B1:B3. Thanks, GB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif & Sumif with Multiple criteria | Excel Worksheet Functions | |||
Sum column information based on multiple criteria | Excel Worksheet Functions | |||
Get cell value with multiple criteria lookup | Excel Worksheet Functions | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) |