V LOOK UP in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2084658%22%20slang%3D%22en-US%22%3EV%20LOOK%20UP%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084658%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20worksheet%20has%20the%20name%20of%20the%20company%20in%20column%20A%20and%20a%20corresponding%20authorization%20number%20in%20Column%20B%3C%2FP%3E%3CP%3EThe%20other%20worksheet%20has%20the%20name%20of%20the%20company%20in%20column%20A%3C%2FP%3E%3CP%3EI%20want%20to%20bring%20over%20the%20authorization%20number%20that%20corresponds%20with%20the%20name%20of%20the%20customer%20in%20the%202nd%20worksheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2084658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

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