So as the title suggests I have been having some problems with Vlookup, i stumbled across this thread first

https://www.excelforum.com/excel-gen...n-vlookup.html

and ran the tests that way - sadly it's still returning this error and ill be damned if i can figure out what's causing it. To sum up what's been done:

1) Copied values from original sheet to new sheet as text
2) Re-written the numbers manually
3) Performed cell value length, isnumber function - proved true and a match respectively.
4) Performed IF function to test if the numbers are exact, returned true value (Sheet1;H12)
5) Performed INDEX/MATCH function on arrays, returned value not available error

I have attached the spreadsheet to suit. I have this nagging feeling i've made a rookie error. but if anyone could help it would be very much appreciated.

Junker