Posted by Kevin Armstrong on July 09, 2001 2:00 PM
I have a combo box containing a listing of account numbers & names pulled from columns 1 & 2 of a table in another tab. The output is the account number to a cell on the first tab. I want to use this output cell (account number) and a vlookup function to populate the rest of this spreadsheet with other data in columns 3 - 6 of the other tab.
The problem is that the lookup function is not recognizing the number in the output cell as matching the number in the table (even though they are the same number. Tried changing the format to text, numbers, but no luck.