Need to compare values of two columns and return the adjacent value to a 3rd
Hello,
I have a large list of model/prices which I need to filter to update a new price list. see below.
I have 4 columns, A B C D
A = First List of Model Numbers
B = New Prices of Models on A
C = Second list of Model numbers
D = Empty Price List
What I want is to be able to Compare C to A and if the C is found on A, to copy B (Adjacent to the model found on A) to D.
Any help is appreciated.
Thanks in advance.
Last edited by redstarx; 02-15-2012 at 01:19 AM.
Pl post a workbook with dummy data with before and after format.
How about something like:
Adjust ranges to suit.
Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
It was my first post, I'll keep it in mind for the next time.Originally Posted by kvsrinivasamurthy
Thank you so much, that worked exactly as I needed it.How about something like:
Adjust ranges to suit.Please Login or Register to view this content.
Cheers,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks