Posted by REmus Garraway on January 11, 2002 7:58 AM
I have a vlookup function and the look up cell does not seem to find the data from the corresponding lookup table. If I go to the table and type in the key the look up cell returns the correct value (everything works well). All formats in both the look up cell and the look up table are the same (general) . This is an exact match , if I change it to true (not an exact match) everything works fine .
Here is the formula
Any suggestions ????
Appreciate your help !!!!