Hello,

I have a spreadsheet with 2 sheets.

Sheet 1 has dates down one column (B), and room numbers across a row(2).

Sheet 2 has dates for meetings in column A, room number it is in in column K, and the data about the meeting in Column L.

I want to have the meeting data(L) to be filled in if the date and room number match.
I can do this if I use;

=IF(AND($B10=Sheet2!A3,Sheet2!$K3=Sheet1!E2),Sheet2!L3,"")

but I can not change 'Sheet2!A3' to be 'if anywhere in this range'.

I think I might be going about this wrong?!

Thank you,

Kerry