In my summary worksheet I have an INDIRECT formula which looks up a
location from col A and a date from row 5, and matches them with an
array in a separate data worksheet, returning the correct result. My
formula looks like this:

=INDIRECT(ADDRESS(MATCH(VLOOKUP($B23,'Supp
Data'!$A$10:$O$110,1,FALSE),'Supp Data'!$A:$A,FALSE),MATCH($U$9,'Supp
Data'!$7:$7,FALSE),,,"Supp Data"))

In the data tables, though, I have several arrays which contain the
same date range in the same row, but only one column containing the
locations - column A. For example, I have data for each month of the
financial year,plus a total column, for Sales, for Budget, for Staff,
etc. These all run across the worksheet from left to right. Each array
has it's own column headings, which are specific to the data in the
array, and these headings are matched on the current month columns in
the summary worksheet.

My question is this: Can I have a 3-way lookup that looks at the
Location in column A, the Name in row 4 and the Date in row 5 and
return the correct cell contents from an array named the same as Name
on another worksheet, even though the locations will not be included in
the array?

I hope I've stated this clearly. I've confused myself, I
think!!!


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=525954