Forum Discussion
V LOOK UP in Excel
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
1 Reply
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.
