Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I copy a field from another spreadsheet based on search? | Excel Worksheet Functions | |||
Copy row based on cell content | New Users to Excel | |||
Copy contents to cell based on value in second cell | Excel Discussion (Misc queries) | |||
Search a cell based on format | Excel Discussion (Misc queries) | |||
How to search and copy cell content to another sheet? | Excel Worksheet Functions |