View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default lookup on 2 (and 3!) dimensions

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.