If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|