How to copy a cell if criteria matches?

Erin S

Hello!

I have included screenshots below. I want to copy the rank from Pivot 1 to Sheet 1 when the Account Name matches.

Nick Korna

Hi @Erin S,

If your pivot is always ordered in rank order, you can use the following formula on Sheet 1:

=MATCH([Account Name]@row, {Pivot Range 1})

For the {Pivot Range} when typing in the formula, press here:

Then find your pivot sheet and pick the column matching the account:

And then press "Insert reference" in the bottom right of the opened window.

This should give you a result like this:

If your pivot is not sorted by rank order, I would suggest using a VLOOKUP, but this would require changing where the columns are on your pivot in order to do it. If this is the case, let me know and I can demonstrate how to do that instead!

Hope this helps, any questions just ask. 😊