Vlookup providing wrong answer.

[Oranjin]

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

BACS16W5A

<tbody>
</tbody>

I'm not clear how 32456 can be read as BACS16W5A. In some cases it is pulling in the correct response.

 

[AhoyNC]

It would help if you could post the formula you are using and a small sample of your data.
One thing to check is if you leave the 4th argument in the VLOOKUP either blank or TRUE it will look for the first approximate match, which may be your issue. If you set the 4th argument to FALSE or 0 it will look for an exact match.

From Excel help:

4. Optionally, you can specify TRUE if you want an approximate match or FALSE if you want an exact match of the return value. If you don't specify anything, the default value will always be TRUE or approximate match.

 

[Oranjin]

The formulas I am using are.

In column L. I had if error around this one too, but removed it in order to trouble shoot it.

=IVLOOKUP(F779,Sheet1!$B$4:$CD$711,48,FALSE)

IN column M

=IFERROR(VLOOKUP(F1135,Sheet1!$B$4:$CD$711,5,FALSE),"")

Data

​

A B C D E F G H I J K L M

RFP Item Boeing Contracting Site Boeing user site Supplier Part Number Corrected Quoted Part Number Part Number Description NAICS Code NAICS Size Standard Three Year Total Estimated Demand Contacts/ Less Contacts (IF AVAILABLE QUOTE WITH CONTACTS) PM MFG Approved <tbody> </tbody>

<tbody>
</tbody>

Starts in column B. One ref in Vlookup goes al the way out to 47. If you need more material, please let me know.
Ref table

REQUESTED PART

PART

Factory

Warehouse

MFG

REQUESTED PART

QTPCOST

REQUESTED QTY

PART TYPE

LEAD TIME

QTY ON HAND

PROMISE DATE

SELECTED COST

SHIP & DEBIT

<tbody>
</tbody>

18969.00

Not in ASW company PG

SB

18969

0

1

0

0.00

0

0

<tbody>
</tbody>