Assistance is greatly appreciated

tel703

New member
Joined
Oct 14, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2013
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
 
Last edited:
Back
Top