Index Formula Trouble

[wilson32294]

Hi I'm trying to match two sets of two columns and provide data from another column in line based on that match.

The following is based on the attached.

Columns A,B,G, and H are all given. I want to compare the values in A2:B2 and match them exactly to values in columns G and H, together. The formula will then pull the value from the corresponding cell C2 in this case and insert that value into I2. I hope this makes sense. I have searched the forums and can only find solutions for one column matches.

Thanks for any help or guidance you an provide.

[avk]

In "I2"

Please Login or Register  to view this content.

[Jonmo1]

Try

=INDEX($C$2:$C$6,MATCH(1,INDEX(($A$2:$A$6=G2)*($B$2:$B$6=H2),0),0))

[wilson32294]

Thanks so much that worked! You all are the best!

[Jonmo1]

You're welcome