I'm loving the new SUMIFS, but I think I want a "SHOWIFS"!
Table looks like this:
1/01/12 1 jones
1/01/12 2 hocking
6/01/12 1 hayes
6/01/12 2 warton
9/01/12 1 wilson
9/01/12 2 jane
13/01/12 1 barry
13/01/12 2 kiley
13/01/12 3 kane
16/01/12 1 kane
16/01/12 2 hoppers
I'd like to look at the whole range, look for a particular date AND a particular number, and return the text (name) from the third column in the relevant row. There will only ever be one correct answer.
Hope this explains it well enough!
Thanks.
Bookmarks