Hello,
I am trying to pull from a column within a table that has mixed data types (numbers & Text comine) and place it into another table. When I am doing so, some items return as the exact match and others read a "N/A". I am looking for an excel formula to return/match all items needed.
Here is sample data:
(Where I would like the data to go) - Item Call
<tbody>
</tbody>
Data Source:
<tbody>
</tbody>
I am trying to pull from a column within a table that has mixed data types (numbers & Text comine) and place it into another table. When I am doing so, some items return as the exact match and others read a "N/A". I am looking for an excel formula to return/match all items needed.
Here is sample data:
(Where I would like the data to go) - Item Call
Ref Number | Item Call |
912364 | Purse |
18666B6 | N/A |
<tbody>
</tbody>
Data Source:
Ref Number (Match) | Item Call (Index) |
912364 | Purse |
18666B4 | Shoes |
<tbody>
</tbody>