V Look Up won't go beyond 009?!

Hi there,

I have a V Look Up Invoicing workbook, based on a series of numbers from 001+...I have a summary page where I can click on a drop down box containing all of the invoice numbers. When it gets to 010 it just returns the values for 001. Similarly for invoice 020 returns the values for 002. Like it is a formatting issue....any ideas how I can correct this please?

Many Thanks in advance!!

Thanks so much Norie....I have attached an example workbook. In the sheet 'Statement and Invoice' cell K19 is where I select the particular drop down.

Many Thanks!

Try

=VLOOKUP(Y19,'Invoice Control'!A18:D28,4,0)

You want exact match.

Brilliant!! Works a treat!! Thanks so so much :0)