Annabel has attended:
Excel Advanced course
Index/Match
How do you find an intersection in a table using index & match functions?
RE: Index/Match
Hi Annabel
Thanks for your question.
I will give you a reference to another web site which explains this and shows several easy to follow examples of how it works. Please see www.contextures.com/xlFunctions03.html#IndexMatch
Amanda