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 autho...
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.