Grizz, Thank you for your solution, I tried to make it work in my problem but I couldn't make it work.

The only difference between the sample spreadsheet that I uploaded here and the one that I need the solution for is that the "look up" table is located on a different sheet.

When I created the sample spreadsheet, I put the look up table on the same sheet where the main information is located just to keep it simple but I guess, my problem requires a different solution when the look up table is on a different sheet.

Am I right, or I am just missing out on something?

Pecoflyer: thank you for the link to that page, indeed it is a great page about the Index function.