Ghost in my VLOOKUP
 

Wow, I have setup a VLOOKUP to search through a tabel of 7 columns x about 15
rows, and to match a string of Alpha-Numeric values, e.g. "BXZ678GP" - but I
am getting all sorts of weird random results! I have checked and checked
again...all seems in order, are there any secrets to using VLOOKUP? I look at
this problem and cant beleive that I am seeing this. Please help. Can I post
an example databse somewhere?

Ghost in my VLOOKUP
 

--Check whether the last argument of vlookup is set to FALSE (0)
--Check whether the actual entry in your database contains any additional
space or -invisible characters after/before
--Make sure the array range is mentioned and the column number specified is
within the array range.

Still you are unable to resolve; post your formula and explain the data
layout..

If this post helps click Yes
---------------
Jacob Skaria


"WildWill" wrote:

Wow, I have setup a VLOOKUP to search through a tabel of 7 columns x about 15
rows, and to match a string of Alpha-Numeric values, e.g. "BXZ678GP" - but I
am getting all sorts of weird random results! I have checked and checked
again...all seems in order, are there any secrets to using VLOOKUP? I look at
this problem and cant beleive that I am seeing this. Please help. Can I post
an example databse somewhere?