I need help (new to formulas)

CMH0112

Newbie,

I am curious if I can merge a Match, Index or Vlookup with an If Then statement.

I have 2 sheets and I want to first validate 2 columns and find a match, then if they match, I want to use that match to pull data from a third column on my lookup_table and move or copy it to my main sheet.

Is this possible?

Paul Newcome

You would use an INDEX/COLLECT.

=INDEX(COLLECT({Column To Pull From}, {1st Match Range}, @cell = "1st match", {2nd Match Range}, @cell = "2nd match"), 1)