| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
getting data out of a table
Hello everyone
Heres my delima, I want to lookup information from diffrent tables ie... I want to fill in information in mutiple cells and have 2 cells determin which table to look in and then have 2 cells determine which row and column index to find the interseting cells information and then place that data in a cell in my spread sheet. thus allowing a math formula to be calculated based on the criterior of the 4 cells. example in the first cell i want to enter "I", second cell "3" this will look in table I3. in the third cell I want to enter "30", in the 4th cell "460" these will be the row and column headers. the interceting cell data is what I want in entered into my spread sheet that will allow a math function to be completed. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
| How can I detail Pivot Table data without creating a table (Excel2007) | Excel Discussion (Misc queries) | |||
| View Pivot Table Source data as a Data Table | Excel Discussion (Misc queries) | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
Threaded Mode
