Look up functions and a one to many relationship
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.
|