G
Guest
Hi,
I'm trying to get my VLOOKUP function to work but am having difficulty.
This is my formula and it is returning the correct answer but I actually
want data from column 52 not 46. When I change the column number to anything
47 or above the function returns 0 when there is data in the relevant columns
(and it's not 0)
=VLOOKUP(BJ6,B5:BH14,46,TRUE)
Are there limits to th number of columns that can be referenced to in a
VLOOKUP function or am I missing something?
I'm trying to get my VLOOKUP function to work but am having difficulty.
This is my formula and it is returning the correct answer but I actually
want data from column 52 not 46. When I change the column number to anything
47 or above the function returns 0 when there is data in the relevant columns
(and it's not 0)
=VLOOKUP(BJ6,B5:BH14,46,TRUE)
Are there limits to th number of columns that can be referenced to in a
VLOOKUP function or am I missing something?