Dear All,
I have an excel sheet with more than 1000 rows with selling item codes.
Some of the item codes have changed and I have got the old codes list and new codes list.
I wanted to put a formula, where excel will find out if this code is CHANGED IN THE ANOTHER COLUMN, then it will change it, if not then it will keep the same code.
Pls find the attached file for the same.
Rgds
AT
Try VLOOKUP do retrieve the correct codes
The problem is that are 90% of the code are same. So i need a selective formula rather then a collective one. Vlook up will retrieve me the code. but then i have to enter all 7000 codes and that is v diff.
What i have is a list of all changed codes with the old and new one.
So what i need is a formula that will look in to the complete column and will give me the new codes in a new column and unchanged code as it is.
In G4, put this formula and drag down:
Formula:
Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Too good thanks boss for your assistance. It worked perfectly fine.
Rgds
As you can see VLOOKUP was the solution. I never implied that it would work alone. But then of course that would have needed some work which someone else did for you
thanks pepe for ur suggestion.
rgds
I've ALREADY answered this in this POST :http://www.excelforum.com/excel-form...92#post3183092
so I'm am really not sure why you felt you had to re-post the question
Edit-
I- list
Last edited by dredwolf; 04-04-2013 at 04:27 AM.
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Dredwolf, yesterday there was some issue with the server. thats why I did not get the reply in my email .
yesterday night i checked, i did not see my post as well.
So i thought let me post it again.
thanks for ur assistance and sorry for the trouble.
rgds
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks