vlookup errors

[Robin]

I have a file which links to seperate file which I use vlookup to return
values from a range. I keep getting corrupt information from the range from
time to time. Not always and this seems to be more of a problem when the file
is larger. Any help with this would be appreciated.
Robin

 

[kassie]

Not clear what you mean with "corrupt information". Suggest you repost, and
give your formula.

 

[Robin]

What i mean by corrupt is i get different results from my look-up table.
Sometimes the results are no where close to having any value in my table.

vlookup(r$132,'g:\planogram\.{bloomnotch.xls}title'/types,26,false)

 

[kassie]

Is your lookup range sorted?

What i mean by corrupt is i get different results from my look-up table.
Sometimes the results are no where close to having any value in my table.

vlookup(r$132,'g:\planogram\.{bloomnotch.xls}title'/types,26,false)

 

[Robin]

My range is sorted, I believe i have covered the standard bases. This is an
unusual error.