Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup with two variables
How do I perform a lookup with two variable that are text?
Cells: A1 is "Away" and B1 is "Tan" This is in Sheet 2: Home Red 1 Home Tan 1 Away Red 4 Away Tan 5 So, I want a formula that will return the number in Sheet 2 column C (in this example) only after it looks at A1 and B1, looks in Sheet 2, and then returns 5. I'm thinking this is a lookup but I'm not sure. Thanks, Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3 LookUp Variables One Result | Excel Worksheet Functions | |||
Lookup with Variables | Excel Worksheet Functions | |||
lookup 2 variables | Excel Discussion (Misc queries) | |||
Lookup (multiple variables) | Excel Worksheet Functions | |||
< |
Excel Worksheet Functions |