If cell A1 in sheet 1 matches cell B1 in sheet 2, then return cell A1 from sheet 2

Question

I have a list of suppliers on sheet 1 in column A

I also have a list of suppliers on sheet 2 in column B, with the matching account numbers in column A.

I need a formula that looks at the suppliers in column A of sheet 1 and if that supplier name exists in column B of sheet 2, then it populates sheet 1 with the data found in column A of sheet 2 (the account numbers).

What formula would work best for this?

Probably VLOOKUP. but hard to say without seeing an example. — L. Scott Johnson, Jul 14 '21 at 10:17

score 0 · Answer 1 · answered Jul 14 '21 at 13:26

0

XLOOKUP should do the trick.

=XLOOKUP(A4;Sheet2!B:B;Sheet2!A:A;"NO_MATCH")

Sheet1

Sheet2

answered Jul 14 '21 at 13:26

DaGunMan

26
2

If cell A1 in sheet 1 matches cell B1 in sheet 2, then return cell A1 from sheet 2

1 Answers1