VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-1387785%22%20slang%3D%22en-US%22%3EVLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1387785%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20lookup%20reference%20is%20the%20first%20data%20in%20both%20my%20schedule%20and%20the%20support%20table.%26nbsp%3B%20The%20function%20only%20recognizes%20the%20data%20in%20cell%20column%20d10%20and%20then%20repeats%20that%20info%20in%20the%20following%20650%20cells.%26nbsp%3B%20I%20can%20change%20correctly%20each%20cell%20by%20highlighting%20the%20cell%20and%20then%20click%20enter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20faster%20way%20to%20get%20VLOOKUP%20to%20function%20correctly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1387785%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

My lookup reference is the first data in both my schedule and the support table.  The function only recognizes the data in cell column d10 and then repeats that info in the following 650 cells.  I can change correctly each cell by highlighting the cell and then click enter.

 

Is there a faster way to get VLOOKUP to function correctly?

1 Reply
Highlighted

@Ernie860 I think you have Automatic Calculation Off in your Excel Sheet so it is not calculating all the data. Just enable automatic calculation and see it resolves your issue.