Hi
I an cuyrrently running a spread sheet that has a whole host of produst codes and product information.
I need to set up another sheet in the same workbook that looks at that sheet and pull fromm it thre separate codes and their associated prosuct info.
The three codes that i need returned begin with (ie first three letters) go! or AOK or NEV.
The sheet containing all the info is called Master Data, the info being in columns A to L with the product ode in column E if that helps.
Could anyone tell me how Ii would go about returning this info and give me an example of the formula Ii could use?
Many Thanks in advance
I an cuyrrently running a spread sheet that has a whole host of produst codes and product information.
I need to set up another sheet in the same workbook that looks at that sheet and pull fromm it thre separate codes and their associated prosuct info.
The three codes that i need returned begin with (ie first three letters) go! or AOK or NEV.
The sheet containing all the info is called Master Data, the info being in columns A to L with the product ode in column E if that helps.
Could anyone tell me how Ii would go about returning this info and give me an example of the formula Ii could use?
Many Thanks in advance