L
Lauri
Creating a report - What function can I use to look up a value from one
column in sheet 1 and find all rows in sheet 2 that contain the matching
value?
Sheet one contains Customer Identification numbers. (Oh, and the same
Customer can have multi ID numbers - unique to address)
Sheet two contains product information for the customers.
EX:
Sheet 1:
123 Invotech
146 Bank of Trusted Presidents
Sheet 2:
123 spreadsheet
123 word processing
123 accounting
123 payroll
146 accounting
146 pos retail
146 health services
Report should show the customer name and columns across with the product
names.
column in sheet 1 and find all rows in sheet 2 that contain the matching
value?
Sheet one contains Customer Identification numbers. (Oh, and the same
Customer can have multi ID numbers - unique to address)
Sheet two contains product information for the customers.
EX:
Sheet 1:
123 Invotech
146 Bank of Trusted Presidents
Sheet 2:
123 spreadsheet
123 word processing
123 accounting
123 payroll
146 accounting
146 pos retail
146 health services
Report should show the customer name and columns across with the product
names.