Code to find values and copy to another sheet

[redjay]

HI all<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I would like a little macro help if possible. Or to be pointed in the direction of the Excel function which would do what I require.<o></o>
<o></o>
I have a very simple worksheet (‘Sales’) in which every time a sale is made, a new row gets added in the following format <o></o>
<o></o>
Column A - Column B<o></o>
Customer Name - Sales ID<o></o>
<o></o>
Now, in another worksheet (‘Customer’) I have a list of all the Customer Names and the price each customer pays.<o></o>
<o></o>
Column A - column B<o></o>
Customer Name - Price<o></o>
<o></o>
I would like some code which cycles through the ‘Sales’ sheet, looks at the customer name in column A and retrieves the correct price for that customer from the ‘Customer’ sheet. I would then like that value to be pasted into column C. End result being that the correct price for each customer is next to each sale in the ‘Sales’ sheet.<o></o>
<o></o>
Hope that makes sense! Many thanks for any suggestions.<o></o>

 

[VoG]

You should be able to use VLOOKUP for that http://www.contextures.com/xlFunctions02.html

 

[redjay]

Thank you- that was a good learning exercise and it works well.

Thanks