#### jonathan92591

##### Board Regular

- Joined
- Oct 27, 2011

- Messages
- 65

Let's pretend I had sheet 1 and sheet 2. Sheet 1 has multiple formulas, sum(), average(), etc. Now the data is on sheet two. Each formula points to product 1, 2, 3. So on sheet 2, product 1, 2, 3 have one data in the column. So I need the formulas on sheet 1 to reference sheet 2. I was thinking of match() or vlookup() but I have yet been able to successively do this.

I sincerely appreciate your time and energy. Thank you.

JT