Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a table with three dimensions (day, name, size).
Row 1 has "size" headings (e.g. "10x10", "20x20", "30x30"). And Columns A & B look like this: Sun Abby Sun Bob Sun Chris Mon Abby Mon Bob Mon Chris Tue Abby Tue Bob etc... Is there a formula that will give me the data for, say, "Monday" & "Bob" & column F? I would usually use VLOOKUP with MATCH, but having another dimension in column B is throwing me for a loop. What about a formula for all three ... e.g. "Tuesday" & "Abby" & "30x30"? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup problem | Excel Worksheet Functions | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |