Thank you, soooo much. Your formula is exactly what I needed - up to a
point, of course!

In my summary worksheet I now 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. So
far, so good. BUT -

In looking more closely at the data tables, I find that I have several
arrays which contain the same date range, but only one column
containing the locations - column A. For example, I have data for each
month of the financial year for Sales, Budget, Staff Levels, 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 addresses the
heading (picking up the array containing all columns with that
heading), the date, and the location? [Just in case you have nothing
else to do :))]


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