Hi Everyone, I'm trying to figure out a vlookup that will display the first result & in the next cell, display the 2nd result, etc
On One sheet (tab), There can be multiple rows of the same Employee ID & Customer Name. What I'm trying to do is on the "Employee" sheet (tab) is bring back only once instance of Customer name & Subtype, IF the "In Region" column is equal to "Y"
Is this something that can be done, or would a pivot need to be used to collapse the customer name down to one record & apply a filter on "In Region" = Y
Thanks!
Sheet - "Customer"
Emp ID Customer SubType In Region
AAAA AAA A Y
AAAA AAA A Y
AAAA AAA A Y
AAAA BBB A Y
AAAA BBB A Y
AAAA BBB B Y
AAAA BBB B Y
AAAA BBC A N
AAAA BBC A N
BBBB CCC A Y
BBBB CCC A Y
BBBB CCC A Y
Sheet - "Employee"
Emp ID AAAA
Customer SubType
AAA A
BBB A
BBB B
On One sheet (tab), There can be multiple rows of the same Employee ID & Customer Name. What I'm trying to do is on the "Employee" sheet (tab) is bring back only once instance of Customer name & Subtype, IF the "In Region" column is equal to "Y"
Is this something that can be done, or would a pivot need to be used to collapse the customer name down to one record & apply a filter on "In Region" = Y
Thanks!
Sheet - "Customer"
Emp ID Customer SubType In Region
AAAA AAA A Y
AAAA AAA A Y
AAAA AAA A Y
AAAA BBB A Y
AAAA BBB A Y
AAAA BBB B Y
AAAA BBB B Y
AAAA BBC A N
AAAA BBC A N
BBBB CCC A Y
BBBB CCC A Y
BBBB CCC A Y
Sheet - "Employee"
Emp ID AAAA
Customer SubType
AAA A
BBB A
BBB B
Last edited: