Find specific text from cell and extract the data from the same row

[roybong]

Hi guys,

Currently, I have a single workbook containing 2 worksheet which are:

Worksheet 1: Price
PRICE.PNG

Worksheet 2: listing
lisitng.PNG

The above is the a sample of the list of 10000 items and what i need to do is to take the item code from Worksheet 2: listing, find the price of the item based on the item code in Worksheet 1: Price, and then extract the price and put it into the price column in Worksheet 2: listing.

I felt it would be a very tiring and troublesome job if i do it manually, so I tried to use some of the excel formula like "vlookup", but it doesnt work out at all. Maybe is the limitation of the excel formula.
As far as i know, vba comes in handy in doing this kind of task, but I am completely new in VBA. Therefore, someone please kindly guide me how to do the coding.
Thanks.

Best Regards,
Roy

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.