index and match

[gav_69]

Hi,

Looking for some help, i have attached a file that i use everyday in work. It takes a while to do because i have to find every price and input it. I was trying to do a vlookup but i think there is to many variables. I was wondering if that index and match formula would work, i am not sure how to use this so if someone could help it would be much appreciated.

On sheet 1 of the attached file i have highled the 2 variables i need to look up or index. I need the information to go into column O IFS MKT PRICE of sheet 1. The information that i want is on sheet 2.

So i need a formula to lookup the info on sheet 2 column C to go into Sheet 1 column O using the highlighted columns C and E.

making sense.
thanks for any help.