Hello I'm desperately seeking help. How can I have two index/match functions in a formula:
=INDEX(Reference,MATCH(value1 & value2, array1 & array2, match type)))
How can I double this formula this does not work:
=INDEX(Reference,MATCH(value1 & value2, array1 & array2, 0),MATCH(value1,Reference,0))
Bookmarks