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

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).

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!