Pull Data from Column 3 of Master Sheet if Values of 2 Columns in Sub-Sheet match with Master Sheet

Athar

Hi, I have a master sheet where I have different columns. I want to pull data from another column of master sheet to different sub-sheet based on following criteria:

1. Column 1 of Master Sheet matches with Column 1 of Sub-Sheet
2. Column 2 of Master Sheet matches with Column 2 of Sub-Sheet

When criteria is met, the Return Value in Column 3 of Sub-sheet shall be Column 3 value (given in master sheet).

Genevieve P.

Hi @Athar

It sounds like a cross-sheet INDEX(COLLECT formula will work for you! Try something like this in your sub-sheet column 3:

=INDEX(COLLECT({Column 3 Master Sheet}, {Column 1 Master Sheet}, [Column 1]@row, {Column 2 Master Sheet}, [Column 2]@row), 1)

Let me know if this makes sense or if you'd like to see screen captures.

Cheers,

Genevieve

Paul Newcome

You are going to want something along the lines of...

=INDEX(COLLECT({Master Sheet 3rd Column}, {Master Sheet 1st Column}, @cell = [Column1]@row, {Master Sheet 2nd Column}, @cell = [Column2]@row), 1)

Genevieve P.

Hi @Athar

It sounds like a cross-sheet INDEX(COLLECT formula will work for you! Try something like this in your sub-sheet column 3:

=INDEX(COLLECT({Column 3 Master Sheet}, {Column 1 Master Sheet}, [Column 1]@row, {Column 2 Master Sheet}, [Column 2]@row), 1)

Let me know if this makes sense or if you'd like to see screen captures.

Cheers,

Genevieve

Paul Newcome

You are going to want something along the lines of...

=INDEX(COLLECT({Master Sheet 3rd Column}, {Master Sheet 1st Column}, @cell = [Column1]@row, {Master Sheet 2nd Column}, @cell = [Column2]@row), 1)

Athar

Thank you so much Genevieve P. and Paul Newcome.

The formula is working correctly.

Paul Newcome

@Athar Happy to help. 👍️

@Genevieve P. I opened the thread to respond but then got sidetracked. I should have refreshed before posting. Then I would have seen you already beat me to it. Hahaha.

Genevieve P.

Haha, teamwork! 😊

Glad that it works, @Athar!

Athar

Thank you.

I have posted another issue https://community.smartsheet.com/discussion/82954/send-automation-email-s-once-in-24-hours#latest.

Can you guys kindly comment on that thread or refer someone you know? I would be grateful for this help.