vlookup and formating?
Posted by Bill on March 08, 2001 10:18 AM
I have a vlookup formula that is working. However when I click on the lookup_value cell, put my curser into the formula bar and hit return the numbers in the lookup_value cell go from left alignment to right alignment and the cell with the vlookup formula changes from the right value to zero.
Also when I use the same "lookup_value cell" mentioned above as part of a "lookup_range" I get the #N/A error.
Do the lookup_value cells and the range cells have to be the same format?