Compare a name in a field and a specific dollar amount to another field

[PETRODATAjames]

Hola!
My worksheet has a name in column B that will match a name in column Z. If there is a match on that row, can the price, column AA be added to column M?

Gràcies
James E.

report-credit-expiration-details_Tribe Fitness Seattle.csv
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	Credit Package ID	Credit Package	Credit Type	Source Type	Customer ID	Customer	Customer Email	Purchase Location	Package Expiration Date	Credits Expired	Currency	Realized Revenue														Credit Package	Price
2	7408	1 Class	All Classes	Purchase	38809			Seattle, WA	4/14/2023	1	USD	38														1 Class	$ 39.00
3	7573	1 Class	All Classes	Purchase	51934			Seattle, WA	4/17/2023	1	USD	38														1 Private training session	$ 105.00
4	8063	1 Class	All Classes	Purchase	51976			Seattle, WA	4/30/2023	1	USD	38														10 Classes	$ 300.00
5	12604	1 Class	All Classes	Purchase	52723			Seattle, WA	5/15/2023	1	USD	39														10 Private 60 Minute Training Sessions	$ 750.00
6	7124	10 Classes	All Classes	Purchase	43679			Seattle, WA	4/5/2023	8	USD	224														12 Private training sessions	$ 960.00
7	8585	10 Classes	All Classes	Purchase	39087			Seattle, WA	5/18/2023	8	USD	224														2 Private Training Sessions Gift Card	$ 210.00
8	7667	20 Classes	All Classes	Purchase	51870			Seattle, WA	5/31/2023	2	USD	50														2 Week Intro (for previous members)	$ 125.00
9	8575	20 Classes	All Classes	Purchase	51571			Seattle, WA	5/18/2023	9	USD	225														2 Week Intro Pass	$ 125.00
10	7181	5 Classes	All Classes	Purchase	51809			Seattle, WA	4/7/2023	2	USD	68														20 Classes	$ 500.00
11	7219	5 Classes	All Classes	Purchase	48068			Seattle, WA	4/9/2023	1	USD	34														20 Private training sessions	$ 1,500.00
12	8679	5 Classes	All Classes	Purchase	48752			Seattle, WA	5/22/2023	3	USD	102														4 Private training sessions	$ 380.00
13	10496	5 Classes	All Classes	Purchase	52301			Seattle, WA	4/30/2023	3	USD	105														5 Class Pack Gift Card	$ 176.41
14	10690	5 Classes	All Classes	Purchase	46154			Seattle, WA	5/5/2023	2	USD	70														5 Classes	$ 175.00
15	11087	5 Classes	All Classes	Purchase	44029			Seattle, WA	5/13/2023	2	USD	70														8 Private training sessions	$ 720.00
16	11108	5 Classes	All Classes	Purchase	48745			Seattle, WA	5/14/2023	2	USD	70														Christmas Class Pack	$ 225.00
17	11130	5 Classes	All Classes	Purchase	52435			Seattle, WA	5/14/2023	1	USD	35														Christmas Personal Training Gift Card	$ 100.00
18	11757	5 Classes	All Classes	Purchase	51837			Seattle, WA	6/7/2023	1	USD	35														Private 30 min 1:1 (10 pack)	$ 450.00
19	11821	5 Classes	All Classes	Purchase	51349			Seattle, WA	6/10/2023	1	USD	35														TRIBE Instructor Training Deposit	$ 500.00
20	12046	5 Classes	All Classes	Purchase	44384			Seattle, WA	6/20/2023	3	USD	79.2														TRIBE Reformer Certification Training	0
21	2980	Private 30 min 1:1 (10 pack)	Appointments	Purchase	37250			Seattle, WA	5/2/2023	6	USD	240
22	7179	Private 30 min 1:1 (5 pack)	Appointments	Purchase	36764			Seattle, WA	4/7/2023	4	USD	200
23	12254	TRIBE Instructor Training Deposit	TRIBE Instructor Training Deposit	Purchase	51223			Seattle, WA	4/30/2023	1	USD	500
24	12307	TRIBE Instructor Training Deposit	TRIBE Instructor Training Deposit	Purchase	45626			Seattle, WA	6/6/2023	1	USD	500
report-credit-expiration-detail

 

[Fluff]

How about

=XLOOKUP(B2,$Z$2:$Z$20,$AA$2:$AA$20,"")