Hi everyone,
I'm trying to perform a lookup where the contents of two cells are compared to return a value. I'm fairly sure Index-match-match is the way to go on this, having done something previously (but on a spreadsheet I don't have access to copy my formula from!). I need to see where I'm going wrong, Index arrays always cause me headaches as I forever get the syntax confused; I don't use them often enough to remember.
I've attached a simplified version of what I need with the expected results entered beneath in red.
Any help gratefully received, especially if you can tell me the mistake I made too to improve my understanding. Likewise if there's a better and more robust method, I'm open to that too
Dabooka
Bookmarks