Your are correct. I didn't realize that column A was hidden on sheet2, and I
needed to index column B. thanks.

"KL" wrote:

Hi,


I tried the
formula suggested and I get an #N/A.

This means that either the date from D1 doesn't exist in range Sheet2!A:A
or otherwise either D1 or Sheet2!A:A contains text looking like date (which
is in principle the same as the former). This error is most probably
returnned by the function MATCH.

Should I enter this formula as an array?

Yes, if you want to select a range 7 rows high and 10 columns wide paste the
formula into the formula bar and the hit Ctrl+Shift+Enter in order to
introduce the formula in all cells at once.

Or to introduce the values individually you could use the following formula
e.g in cell [F9] and copy it 6 rows down and 9 columns left:

=OFFSET(INDEX(Sheet2!$A:$A,MATCH($D$1,Sheet2!$A:$A ,0)),-6+ROW()-ROW($9:$9),2+COLUMN()-COLUMN($F:$F))

Also, be warned that both formulas will return the #REF! error if the
searched value is found in row 6 or higher of Sheet2.

Regards,
KL