Hi all,
I have a list of products in column A with their corresponding prices in column B (Several thousand rows long)
In column C (Can be any column, doesn't matter) I have a small list of products (A few hundred rows long)
I would like to somehow extract the prices for those products from column B and 'paste' them in the adjacent column of the short list of products so that the product and price match up.
If a product isn't there then maybe paste a zero or something that denotes that the product wasn't found in column A.
Any help is much appreciated.
Bookmarks