V LOOK UP in Excel

[AS248]

One worksheet has the name of the company in column A and a corresponding authorization number in Column B

The other worksheet has the name of the company in column A

I want to bring over the authorization number that corresponds with the name of the customer in the 2nd worksheet

[#2]

@AS248 

Let's say the first sheet is named Sheet 1.

In cell B2 on the second sheet, enter the following formula

=IFERROR(VLOOKUP(A2, 'Sheet 1'!$A$2:$B$1000, 2, FALSE), "")

If the data on Sheet 1 extend below row 1000, adjust the range $A$2:$B$1000 accordingly.

Fill or copy down from B2 as far as needed.