vlookup errors

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not clear what you mean with "corrupt information". Suggest you repost, and
give your formula.
 
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)
 
Is your lookup range sorted?

Robin said:
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)
Click to expand...
 
My range is sorted, I believe i have covered the standard bases. This is an
unusual error.
 
Back
Top