Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ghost files and more! | Setting up and Configuration of Excel | |||
Ghost in the Machine - 1004 Vlookup & On Error Duo Trouble | Excel Worksheet Functions | |||
Ghost Formulas | Excel Discussion (Misc queries) | |||
ghost macro | Excel Worksheet Functions | |||
Ghost Links | Links and Linking in Excel |