What is the correct formula I need to use to return a result when cross checking multiple criteria? I believe I need to use Index Match but cannot quite format it correctly to provide the result I needed.
I have provided an example spreadsheet.
I 'd like to cross check and match the data in columns A, B and C against the data in columns G, I and J. If all three criteria match, I'd like the corresponding information in column K to appear in column D.
I hope I've explained myself well enough here.
Please can someone help?
Bookmarks