MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Posted by John S. on March 08, 2001 10:26 AM

Classic problem. When you select the cell and it right justifies you are formating the cell back t a number. right now it is in text format. Unfortunatly you can not just convert the entire column to text. In another column use =value(text(A1,0)) where A1 is your problem cell. Then make sure your lookup is in number format.

Posted by Bill on March 08, 2001 12:19 PM


Thanks for the help!