I have two tables set up. Each on a separate tab. When I set up the lookup, I clicked over to the other tab and highlighted the fields I had on the table, finished the formula and hit enter. I went back and it worked correctly. Where I have run into problems now is when I entered more information on the tables. The formula is the exact same in each cell (referencing the name of the table rather than the corresponding cell reference).
The formula seems to work properly with each row, it doesn't return and N/A. Instead it returns the last few characters of the cell I need. For example, I have two lines in the lookup table that are the same thing but end with a " - Blue" or " - White"
The formula returns "Blue" and "White" instead of "xxxxxxx - Blue" or "xxxxxxx - White"
I'm at a loss here.
Bookmarks