Hello,
I need to attach product managers to products. The problem I am having is that Vlookup is pulling in the wrong name. So for product 32456 it is pulling in product manager X instead of the appropriate one, Y. I have a column set up next to it, that is referencing the same range, and it is pulling in PCD. This is also wrong. I found where PCD is. For the first column in the table, where PCD is, the product entered there is
<tbody>
</tbody>
I'm not clear how 32456 can be read as BACS16W5A. In some cases it is pulling in the correct response.
I need to attach product managers to products. The problem I am having is that Vlookup is pulling in the wrong name. So for product 32456 it is pulling in product manager X instead of the appropriate one, Y. I have a column set up next to it, that is referencing the same range, and it is pulling in PCD. This is also wrong. I found where PCD is. For the first column in the table, where PCD is, the product entered there is
BACS16W5A |
<tbody>
</tbody>
I'm not clear how 32456 can be read as BACS16W5A. In some cases it is pulling in the correct response.