Vlookup picking up random data and not exact match

[Excheltenham]

hi all,

I can't seem to fathom this one.

i have work book with a basic vlookup(a1,'sheet2'A:G,4,0)
where a1 is a string of digits 345678

Sadly the vlookup retruning random answers pretty much where 3,4,5,6,7,8 are present in the sheet

I thought 0 returned exact values only..

Where am I going wrong ?

 

[Special-K99]

I don't thibnk you can have range A:G
VLOOKUP is a VERTICAL lookup.
Your range implies both vertical AND horizontal.

What are you trying to achieve?

 

[sanrv1f]

Could you post some sample data and the results of the Vlookup

 

[Excheltenham]

find a1 from the first sheet , to find match in row b on second sheet then move 4 cells and collect that total figure ..

data is
Account, Cost Centre, Invoice, Gst, Total..

so i want exact account no. match to return value in total column it relates to

 

[Excheltenham]

please see above

 

[RoryA]

That would be:
vlookup(a1,'sheet2'A:G,5,0)
not
vlookup(a1,'sheet2'A:G,4,0)

since the data you want is in the 5th column of your lookup range.

 

[steve the fish]

Your lookup value is found in column B?