VlookUp?

[ExcelNewbie150]

Hello

I have an excel sheet with two tabs one tab has names and the other has quantities -- I need to use a formula that returns the quantities next to the corresponding names - i think this can be done by vlookup but I am not sire

Tab 1

Identifier	Day	Side	Quantity
B034CL3	5/1/2024​	Sell	?
BNZJDK3	5/2/2024​	Sell	?
BFH3QX1	5/3/2024​	Sell	?
7622043	5/4/2024​	Sell	?
BP4W2Q6	5/5/2024​	Sell	?
B4Y0230	5/6/2024​	Sell	?

Tab 2

Identifier	Quanity
B034CL3	154,823
BNZJDK3	7,500
BFH3QX1	1,250
7622043	155,487,892
BP4W2Q6	74,598
B4Y0230	154,793

 

[Alex Blakenburg]

Either of these should work:

Book7
	A	B	C	D	E
1	Identifier	Day	Side	Quantity	Alternative Xlookup
2	B034CL3	5/1/2024	Sell	154823	154823
3	BNZJDK3	5/2/2024	Sell	7500	7500
4	BFH3QX1	5/3/2024	Sell	1250	1250
5	7622043	5/4/2024	Sell	155487892	155487892
6	BP4W2Q6	5/5/2024	Sell	74598	74598
7	B4Y0230	5/6/2024	Sell	154793	154793
Sheet1

Cell Formulas
Range	Formula
D2:D7	D2	=VLOOKUP($A2,Sheet2!$A$2:$B$7,2,FALSE)
E2:E7	E2	=XLOOKUP($A2,Sheet2!$A$2:$A$7,Sheet2!$B$2:$B$7)