Two tables on separate worksheets - need result of text in worksheet 1

[jlr123]

I have two tables on separate worksheets in a workbook. Need formula to match column B in
worksheet 1 with column B in worksheet 2 then return the text that is in column A in worksheet 2 into a new column (D) on worksheet 1.
Thanks so much!

 

[jlr123]

send to lr2558@gmail.com (personal email)

 

[Toadstool]

Hi JLR123

Some comments:
You had "Worksheet '2'" instead of You had "'Worksheet 2'" in some places so it was looking for a 2.xlsx workbook.
You also had Manual Calculation set so you wouldn't see all changes at the same time. I suggest Automatic unless your sheet is huge.
Key fields should never be entirely numeric as you could hit errors matching Cust No if it changes in a column or rounding errors.

Here's your two sheets with working formulae (and I've emailed the larger sheet).

JLR123-V2.xlsx
	A	B	C
1	SP	Cust No	CustomerName
2	ZZ1	0101.00	Example Name 1
3	ZZ1	0101.00	Example Name 1
4	ZZ1	0103.00	Example Name 1
5	ZZ1	0103.00	Example Name 1
6	ZZ1	0103.00	Example Name 1
7	ZZ1	0103.00	Example Name 1
8	BSB	0103.01	Example Name 2
9	BSB	0103.01	Example Name 2
10	WAM	0103.05	Example Name 3
11	WAM	0103.05	Example name 3
Worksheet 2

JLR123-V2.xlsx
	A	B	C	D	E	F
1	SP	Cust No	CustomerName	Wksheet 2 SP
2	ZZ1	0103.00	Example Name 1	ZZ1
3	ZZ1	0103.00	Example Name 1	ZZ1
4	ZZ1	0103.00	Example Name 1	ZZ1
5	ZZ1	0103.00	Example Name 1	ZZ1
6	ZZ1	0103.00	Example Name 1	ZZ1
7	ZZ1	0103.00	Example Name 1	ZZ1
8	ZZ1	0103.00	Example Name 1	ZZ1
9	ZZ1	0103.00	Example Name 1	ZZ1
10	ZZ1	0103.01	Example Name 2	BSB
11	ZZ1	0103.01	Example Name 2	BSB	BSB	Result should be BSB
12	ZZ1	0103.05	Example Name 3	WAM	WAM	Result should be WAM
13	ZZ1	0103.05	Example name 3	WAM	WAM	Result should be WAM
Worksheet 1

Cell Formulas
Range	Formula
D2:D13	D2	=IFERROR(INDEX('Worksheet 2'!A:A,MATCH(B2,'Worksheet 2'!B:B,0)),"")

 

[jlr123]

Thanks so much!