=IF(ISBLANK($A$66:$A$543),"",(IF(ISBLANK(E$2),"",(VLOOKUP($A$66:$A$543,Sheet1!$A$4:$AA$397,HLOOKUP($B$2:$AI$2,Sheet1!$B$1:$Z$2,2,FALSE),FALSE)))))
Above is my formula. This formula is on my report page. My sheet1! is where we enter the data needed for the report. The only thing that seems to be a problem is that it does not "sum" two identical customers.
This is a spot of my report:
Bravos Supply
CalPly Pico Rivera L&W 1
Calply Sun Valley L&W
Charles Hardy Co, Paramount, CA
Foundation Building Materials - Orange, CA
Foundation Building Materials - N HOLLY 1
Glesby Building Materials
Great Western Bldg Material - Oxnard
Great Western Bldg Material - Pico Rivera 1
JC Building Supply
Jones Lumber, Lynwood, CA
Lowe's - Norwalk
Nichols Lumber, Baldwin Park CA
This is a spot of Sheet1!:
CalPly Pico Rivera L&W 1
Calply Sun Valley L&W
Foundation Building Materials - N HOLLY 1
Foundation Building Materials - Orange, CA
Charles Hardy Co, Paramount, CA
Great Western Bldg Material - Oxnard
Great Western Bldg Material - Pico Rivera 1
JC Building Supply
Nichols Lumber, Baldwin Park CA
What happens with my report is: We enter data on Sheet1!
and after formula it registers in the report. The problem I am
having is when a customer "Calply Pico Rivera L&W is on my
data sheet twice because of different warehouses I cannot get
my "report" to add common name entries "1" + "1" that each
have a numerical data entry.
Wow does this make sense....I sure hope so.
Above is my formula. This formula is on my report page. My sheet1! is where we enter the data needed for the report. The only thing that seems to be a problem is that it does not "sum" two identical customers.
This is a spot of my report:
Bravos Supply
CalPly Pico Rivera L&W 1
Calply Sun Valley L&W
Charles Hardy Co, Paramount, CA
Foundation Building Materials - Orange, CA
Foundation Building Materials - N HOLLY 1
Glesby Building Materials
Great Western Bldg Material - Oxnard
Great Western Bldg Material - Pico Rivera 1
JC Building Supply
Jones Lumber, Lynwood, CA
Lowe's - Norwalk
Nichols Lumber, Baldwin Park CA
This is a spot of Sheet1!:
CalPly Pico Rivera L&W 1
Calply Sun Valley L&W
Foundation Building Materials - N HOLLY 1
Foundation Building Materials - Orange, CA
Charles Hardy Co, Paramount, CA
Great Western Bldg Material - Oxnard
Great Western Bldg Material - Pico Rivera 1
JC Building Supply
Nichols Lumber, Baldwin Park CA
What happens with my report is: We enter data on Sheet1!
and after formula it registers in the report. The problem I am
having is when a customer "Calply Pico Rivera L&W is on my
data sheet twice because of different warehouses I cannot get
my "report" to add common name entries "1" + "1" that each
have a numerical data entry.
Wow does this make sense....I sure hope so.