Thats not what I need. I have 300 customers listed, I need the individual
total. The next two rows on the tab 1 are for customer 847300002 and so on.
I need to pull pub one total for each customer, and also pub 2 total for each
customer and populate the total into the appropriate column on tab 2.
"Peo Sjoblom" wrote:
Looks like you could use a SUMIF
=SUMIF(Sheet1!Pub_Range,"Pub1",Sheet1!Total_Range)
Regards,
Peo Sjoblom
"Josh O." wrote:
I am trying to create a lookup formula to pull data from on worksheet to
another.
On tab 1 there are 2 sets of data for two different publications, on tab 2
cell a1 I want to lookup the value from tab 1 total column for pub 1 and on
tab 2 cell b1 I want the total from pub 2. The spreadsheet is laid out as
follows:
Tab 1
Customer|Customer #|...|Pub #|Total
Any Co. |847300001 |...|Pub 1|$1.00
Any Co. |847300001 |...|Pub 2|$2.00
Tab 2
Customer|Customer #|Pub 1 Total|Pub 2 Total
Any Co. | 847300001 | $1.00 | $2.00
I have all the info on tab 1, and most of tab 2. I just need to make a
formula to lookup the pub total for each pub.
|