Hi,

I would like to know a formula that will pull out the value from Sheet 1 to Sheet 2 (for example).

Sheet 1 has 5 Columns (Salesman, Territory, Dimension, Sales Amt, Cost). This sheet is basically a system export.

Sheet 2 has 5 Columns too (Salesman, Territory, Dimension, Sales Amt, Cost). This sheet is used for reports.


Could some one please guide me with a formula which will fetch result from Sheet 1 to Sheet 2 (Column "Sales"), only if the First 3 columns (Salesman, Territory, Dimension) match in both the sheets.

Example of Sheet 1 is as below:

Sales Man Territory Dimension Sales Amt Cost
John New York Tissue 1000 200
Alfred Washington Soda 2100 700
John New York Soda 2050 1500
Alfred New York Tissue 2000 500
Leo Washington Soda 200 100
Leo New York Tissue 3500 1500