I want to autofill cells from one sheet within a workbook based on a specific criteria
Example:
Located on sheet 1 in Cell A1 I enter "Store 1"
Located on Sheet 2 in cells A1:A20 are the names of the 5 sales people for Store 1
On sheet 1 I want all the sales people to populate in cells C1:C5 automatically when sheet 1, cell A1 contains "Store 1"
I am using the following formula but it only returns the first name in the list
={IF(A1="Store 1",Sheet2!A1:A20,0)}
Thanks in advance for any insight
Tim
Example:
Located on sheet 1 in Cell A1 I enter "Store 1"
Located on Sheet 2 in cells A1:A20 are the names of the 5 sales people for Store 1
On sheet 1 I want all the sales people to populate in cells C1:C5 automatically when sheet 1, cell A1 contains "Store 1"
I am using the following formula but it only returns the first name in the list
={IF(A1="Store 1",Sheet2!A1:A20,0)}
Thanks in advance for any insight
Tim
Last edited: