Thank you,
The formula given works fine, however when applying the same given formula to a different cell formula contains the LOOKUP formula below after changing some values it did not works with me!!
Would you please edit the following formulas in the same way as you did with the first one.
INDEX is A38:G92
=LOOKUP(M10,A38:A92,C38:C92)
Regards,
Bookmarks