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
Bookmarks