I am trying to extract data from a spreadsheet on my company intranet based on 2 criteria and display it in my own spreadsheet.
For example in the attached workbook if I wanted to lookup Ian Barry and only display his data.
The company spreadsheet has quite a bit more data in it.
Any help appreciated
Bookmarks