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!
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).