This is the metthod of using Excel functions INDEX and MATCH together when you need to get a result by matching two or more fields. It can be dine by using the CONCATINATE notation "&". This is an
array formula, so you may need to press ctrl+Shift+enter key to make it work..Hope this helps. :)
