Hello all,
I have read through a hundred posts and thats why I'm here. Apologies to the readers of redundant posts but I can't seem to get any functions to work. So here goes ...
I have sheet2 which has data I need transferred to sheet1. Both sheet1 and sheet2 have a common field, product #, but out of order so copy and paste obviously won't work. In Sheet2, the Sell Price values are in, but I need those transferred to Sheet1.
Sheet2
Product# Sell Price UOM
Sheet1
Product# Product Sell Price
In sheet2, there are more Product#'s than on Sheet1 so I need an error function, or rather a way to hold those values back and just bring the ones that match sheet1 over.
I hope this is descriptive enough. I thought I could extrapolate something I've found in another thread, but I can't seem to get the right function going. Any help is appreciated
Thanks!
I have read through a hundred posts and thats why I'm here. Apologies to the readers of redundant posts but I can't seem to get any functions to work. So here goes ...
I have sheet2 which has data I need transferred to sheet1. Both sheet1 and sheet2 have a common field, product #, but out of order so copy and paste obviously won't work. In Sheet2, the Sell Price values are in, but I need those transferred to Sheet1.
Sheet2
Product# Sell Price UOM
Sheet1
Product# Product Sell Price
In sheet2, there are more Product#'s than on Sheet1 so I need an error function, or rather a way to hold those values back and just bring the ones that match sheet1 over.
I hope this is descriptive enough. I thought I could extrapolate something I've found in another thread, but I can't seem to get the right function going. Any help is appreciated

Thanks!