CODEWITHSUNDEEP
excelvbaexcel-formula
David Johnson
David Johnson

Reputation: 11

Excel Customer List

I have Excel workbook with 2 sheets, a form sheet and a customer data sheet. The customer data sheet has an ID in column A (ex. F669) with the customer's full name in column B. Is there away I can get a list of all customer names that have the same ID to show up on my form sheet based on the ID that I enter on that form?

Thanks,

I've tried using a Unique function, but didn't work. I tried the following formula, but it only shows two of the customers that has the ID that I entered.

=IFERROR(INDEX(ContactRecs!B:B,SMALL(IF(ContactRecs!$A:$A=FormHome!$S$45,ROW(ContactRecs!$B:$B)),ROW(7:7))*1,1),"")

I'm not sure what else to try.

Thanks,

Upvotes: 1

Views: 116

Answers (1)

Ike
Ike

Reputation: 13054

you can use the FILTER formula:

=UNIQUE(FILTER(ContactRecs!B:B,ContactRecs!A:A=FormHome!$S$45))

It filters column B on ContactRecs based on the ID given on your FormHome-Sheet. As you already tried UNIQUE I added it to the filter result.

Upvotes: 1

Related Questions