Vlookup Array limit?
I'm using Vlookup to find a cell and return the value of the cell next to it from a list in two columns. However, it seems I can only go down 50 or so cells to get the correct answer. If I use the whole list, I only get the last cells value. Why?
For Example,
I want to lookup and match a value that's in cell B68 and the list starts at B1, the cell - I know to be the correct answer - is in B63, but the formula result is the value in B68.
Any/all assistance is greatly appreciated.
Thank you
|