Hello all,
I have an item in cell A1 on tab1, the description is
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>
I have an item in cell A1 on tab1, the description is
AMERICAN EXPRESS SETTLEMENT 131227 1429529449 THE WOODLAND1429529449 I have a list on tab 2 in column A. One of the items in the list is 1429529449. What I want to do.............. In cell B1 on tab1, I want a formula that will be able to cross reference cell A1 to the list on tab2, and if any number within the description matches any item in the list on tab2, it will return the value on tab 2 in column B in the same row as the match. The problem I am having is that the description I want to match to the list is not an exact match, it has a lot of other miscellaneous data. I have been stuck on this for a very long time. Any guidance would be awesome! |
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>