Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX FORMULAS & MULTIPLE TABLES
Hello everyone,
I am using the below formula to capture data from a table in my spreadsheet: =INDEX(F3:H22,MATCH(B9,E3:E22,0),MATCH(B3,F2:H2,0) ) Within the spreadsheet I have an additional 2 tables with data range K3:M22 and P3:R22. I want to be able to enter either 1 2 or 3 into cell B2..... Depending on the reply; 1 will take data from F3:H22 - 2 will take data from table K3:M22 and - 3 will take data from P3:R22 Thank you all in anticipation of your help. Kind regards Aaron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using 3 tables in one spreadsheet and utilising index formula to retrieve information | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
SUMPRODUCT or INDEX/MATCH for multiple conditions and multiple rec | Excel Discussion (Misc queries) | |||
summating vlookup or index formulas | Excel Worksheet Functions | |||
index/ match formulas orice | Excel Worksheet Functions |