Hello -
Help, please. Vlookup is skipping over some columns as though they don't exist. For instance, if I type in the following formula, =VLOOKUP(J2,$C$2:$G$6,3,FALSE), rather than getting what's in the third column, Vlookup returns what's in Column 10 or Column 5. I have never experienced this before, and I've already googled it.
Has anyone encountered this before?
I checked the following:
- The cells between Columns 3 and 10 are not blank.
- The cells are all formatted the same way.
Please can anyone help me? An example of a table is pasted below. The first cell is Cell C2. I expected to get "Jill" as a return from the formula above (where J2 = Project 1). Instead, I got '3'.
Why did it skip over the columns that contain "Team A" or "3".
Any help will be appreciated!
Project List Leaders Team Members Groups affected (Only dropdown options can be selected) Number of people
Project 1 Doris Jill Team A 3
Project 2 James Samantha Team B 2
Project 3 Martha Joe Team C 6
Project 4 Avinash Mark Team D 10
Bookmarks