returning answer based on matching cells then changing answer

hi guys

i need to find the following

if the answer in CA2 is in column D AND the answer from CD4 is in Column C then i need it to return the answer from column G of the same row the other criteria is matched

thank you

Try something like this:

=INDEX(G$2:G$100,INDEX(MATCH(CA2&CD4,D$2:D$100&C$2:C$100,0),0))

Changing the 2 and 100 to whatever fits your data.

hi falcon that works great superb as ever
thank you

Happy to help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.