Match & Replace question

This is what I have....
P-id P-SKU P-SKU C-id
88438 CATDJ AC1030812 528
88439 CATPD AC1030812 168
88440 CATSE AC1030812 532
88441 CLA96001 AC2061414 528
88442 CLA96007 AC2061414 531
88443 CLA96009 AC2061414 28
88444 CLA96012 AC2061414 532


This is what I need..
P-id = P-SKU P-SKU = C-id

into this...

P-id = C-id

I have a list of about 18000 rows of P-SKU C-id
and 800 rows of P-id P-SKU of single P-id and single P-SKU

any ideas thanks guys

Can you please upload a workbook with a before and after example in it.

Thanks

http://natesit.com/test.xlsx

I will assume that all data in the sample spreadsheet is in the correct columns as in your actual spreadsheet. If so, use this formula (if not, adjust this formula to match in your actual) to return the Product ID given the SKU (of course, adjust the absolute range references to suit the full range of your actual data):

Formula:

Please Login or Register  to view this content.

The MATCH function will look up the row number of the SKU from column F in column B, and return this value to the INDEX function, which will then return the corresponding Product ID of that SKU.

Now the formatting is up to you. It might be easier to simply add this into, say, cell H2 and copy the formula down, and then move some columns around to have it display how you want it, or perhaps even on a new worksheet in the same workbook would suffice...this is all up to you.

Let me know how this goes for you, and if I have helped you, please don't forget to click the star and mark this thread as solved.

Thanks

My wife and I are sitting here going crazy LOL running into a error, here is the link to the full file to give you a better idea deliminator is ;

Untitled-1.jpg

http://natesit.com/mod.csv

keeps getting errors... what am I doing LOL

I really appreciate your help too thanks

I had my wife try it and I think she got it update in a sec

it worked on her computer but not mine LOL same Excel Ver

the NA is most likely categorized items not on the list im going to play with it more thanks a ton been working on that all day LOL

Yes that's what the "#N/A" errors are.

Let me know how you get on after having a look at my most recent attachment.

What is the error that you are getting on your computer???