Forum Discussion
Vlookup
Hey Guys. I'm hoping someone can assist me but my vlookup doesn't seem to be searching the whole sheet, Just the first column. Vlookup, Excel I'm using =VLOOKUP(A2, Sheet1!A:AJ, 2, FALSE) Can ...
VLOOKUP searches for the lookup value (A2) in the first column of the lookup range (i.e. Sheet1 column A). If it finds a match, it returns the value from the column of the lookup range specified in the 3rd argument. In your example, the column index is 2, so it would return a value from Sheet1 column B.
OOOH! that where I'm going wrong. So if my return was in column B is wouldn't just go two cells across.