Using VLookup and Conditional Formatting

[Andy B.]

I am currently working on a project with the company I am working for and we
are having some difficulty with an excel formula. We're basically working out
of two different spreadsheets in a workbook and the only common ground
between the two is the column for part numbers. We used VLookup to pull data
from the first spreadsheet into the second with some conditional formatting.
The vlookup was based on part number.

Here is the problem. Because it involves data from four of our different
plants, some of the part numbers are listed twice, but contain completely
different cost, supplier and buyer information that we need to capture. I
suppose that ideally, is there some sort of function that can tell excel to
only pull the data from one entry of the part number once before trying to
find a second and pulling data like that until it cannot find another entry
and thus, end?

Thanks everyone for all the help! It is greatly appreciated as always!

 

[Ashish Mathur]

Hi,

Please post an example so that the problem is clear.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Stefi]

I'm afraid you can't solve the problem without adding a plant column to both
worksheets and use concatenation of plant identifier and part number as
search key in VLOOKUP.

Regards,
Stefi

„Andy B.†ezt írta:

 

[Andy B.]

The formula I am using currently is =IF(ISNA(VLOOKUP($A2,'Pull Part
Candidates'!$A:$R,COLUMNS($A2:C2),0)),"",IF(VLOOKUP($A2,'Pull Part
Candidates'!$A:$R,COLUMNS($A2:C2),0)="","",VLOOKUP($A2,'Pull Part
Candidates'!$A:$R,COLUMNS($A2:C2),0))).

 

[Stefi]

You should post the exact structure of your sheets!
Stefi


„Andy B.†ezt írta: