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:
- Column 1 of Master Sheet matches with Column 1 of Sub-Sheet
- 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).
Help Article Resources
Check out the Formula Handbook template!