VLOOKUp not returning data....

Hi guys,

I`m using a vlookup but not seeing the data returned that I expect

oN my sheet there are 2 tabs.

On my first tab (main):

I have a coulmn called VLOOKUP, column M. Where is no N/A there is a Barcode (13 digit number).

On my 2nd tab, P.V. ex, I am trying to insert a vlookup in cell F5 to say:

=VLOOKUP(A5,Main!$C$14:$M$5617,7,FALSE)

bASICALLY if cell A5 is on the main tab, which it should be in column D, then return the barcode/value from column M... I am getting N/A any reason why pelase?

Thank you

It seems to be completely wrong!

As far as I can see, the lookup value is to be found in column D and column M is 10 columns away from that to the right:

=VLOOKUP(A5,Main!$D$14:$M$5617,10,FALSE)

Thank you all!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.