copy a cell value based on search of another cell
I have a worksheet that has two sheets to it
on sheet A i have a list of product codes and the name of an image that goes with them on sheet B i have a list of products codes and the productID number from my database. what i need to do is search sheet B for the product code that matches sheet A and then insert the productID onto sheet A is there an easy way to do this? Thanks, |
copy a cell value based on search of another cell
You can use VLOOKUP for this, or an INDEX/MATCH combination. Give us
some idea of which columns you are using on the sheets if you want a specific formula to do it. Pete On Nov 12, 5:26*pm, Pendal wrote: I have a worksheet that has two sheets to it on sheet A i have a list of product codes and the name of an image that goes with them on sheet B i have a list of products codes and the productID number from my database. what i need to do is search sheet B for the product code that matches sheet A and then insert the productID onto sheet A is there an easy way to do this? Thanks, |
All times are GMT +1. The time now is 10:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com