View Single Post
  #1   Report Post  
frankjh19701 frankjh19701 is offline
Member
 
Posts: 89
Default 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