Rows columns

[alliswell]

Hi everybody

I have some data in B2:F25, A2:A25 are customer names with repeated customer.

When in A30 i enter customer name, then from B30:F30 i shud get his records with the help of rows and columns formulas without helper column

Thanks & regards

 

[Asbestos_Jen]

I'm not exactly sure what you're looking for, but it might be this:

2024-03-25.xlsx
	A	B	C	D	E	F
1	NAME	Surname	DATE	Contact	Item4	Item5
2	Valentine	Lawson	1-Jan-23	Valentine@email.com	18	17
3	Marty	Carroll	17-Jan-23	Marty@email.com	12	12
4	Geneva	Melton	20-Jan-23	Geneva@email.com	27	26
5	Maria	Conway	20-Jan-23	Maria@email.com	24	23
6	Penny	Hebert	27-Jan-23	Penny@email.com	20	29
7	Alexis	Garrison	27-Jan-23	Alexis@email.com	12	21
8	Damian	Manning	5-Feb-23	Damian@email.com	22	11
9	Alonso	Maddox	9-Feb-23	Alonso@email.com	19	14
10	Richard	Roberts	11-Feb-23	Richard@email.com	18	12
11	Rose	Bell	28-Feb-23	Rose@email.com	27	21
12	Lou	Burns	13-Mar-23	Lou@email.com	14	21
13	Roland	Gay	13-Mar-23	Roland@email.com	19	20
14	Dixie	Cooper	20-Apr-23	Dixie@email.com	30	11
15	Rodrick	Keller	22-Apr-23	Rodrick@email.com	29	19
16	Christopher	Rosario	25-Apr-23	Christopher@email.com	18	14
17	Alexander	Goodwin	26-Apr-23	Alexander@email.com	17	30
18	Elsie	Strickland	7-May-23	Elsie@email.com	14	16
19	Pearlie	Griffin	10-May-23	Pearlie@email.com	17	16
20	Zelma	Allison	26-May-23	Zelma@email.com	14	13
21	Britt	Young	5-Jun-23	Britt@email.com	14	23
22	Melissa	Vargas	14-Jun-23	Melissa@email.com	26	18
23	Ezequiel	Wyatt	22-Jun-23	Ezequiel@email.com	15	26
24	Jordan	Baldwin	5-Jul-23	Jordan@email.com	19	22
25	Stephen	Osborn	19-Jul-23	Stephen@email.com	23	15
26
27
28
29	Pick Name	Surname	DATE	Contact	Item4	Item5
30	Alonso	Maddox	44966	Alonso@email.com	19	14
Sheet1

Cell Formulas
Range	Formula
B29:F29	B29	=B1
B30:F30	B30	=INDEX($A$1:$F$25,MATCH($A$30,$A$1:$A$250),MATCH(B$29,$A$1:$F$1,0))

Named Ranges
Name	Refers To	Cells
Name	=Sheet1!$A$2:$A$25	B30:F30

Cells with Data Validation
Cell	Allow	Criteria
A30	List	=Name

 

[Asbestos_Jen]

I didn't understand what you were asking for when you messaged me. If you have further information related to the post, please post it here instead of sending me a private message.