| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding exact matches using vlookup
I am getting #N/A errors even when I have an apparently exact match in my
table array to the lookup value. I know that excel requires the formats to be exactly the same and I can force the match if I copy the lookup value from my table array and paste it into the worksheet. Is there an easy way to "fix" my table array. The table array is a reference worksheet I have created which has worked in the past. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding text strings in complex situations | Excel Discussion (Misc queries) | |||
| using vlookup - how do I match 2 spreadsheets w/o same exact numb. | Excel Worksheet Functions | |||
| Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
