Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
I'm trying to solve what I think is a complex formula.
To start with, I have a table (call it table 1) that has 'Age' in the column, and the top row has another variable. Then there are different values in the cells depending on the 'age' selected and the other variable. On a separate tab, I enter the age and the other variable into two different cells. In a third cell, I want to put a formula that goes to table 1, uses the age and the other variable, and returns with the value. How do I program that function into the third cell? Michael Croy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |