Two young enterprising lads (Zack & Jake) bought the local parts and service centre at Walkabout Creek and promptly named the business Walkabout Creek Fixerup Services. However they were having a bit of a problem with what parts were in the shop, so decided to hold a 5 day, in-house team building camp out at the local watering hole. About 3 and a bit days into the bender ( sorry I mean team moral building exercise where they were discussing the need for a spreadsheet), when Zack's missus sent a message to the Publican saying that could he send the useless sod home to fix the damage caused when Rutter the feral boar and Zack's bull Mastiff cross "Fluffy" had a bit of a disagreement about who had rights to the scrap bin. Apparently most of the carrots, beans and only remaining cabbage were scattered about the yard. Zack, you remember the cabbages you were meant to spray for moths last week, but you told the wife that you had run out of the good stuff but there was a small drum of Agent Orange in the back of the shed, that you thought would give the moths a run for their money. The Missus knew something was up when you took off with the big esky and two fishing rods.....
Anyway the accountant Paul, sent our boys a spread sheet with Part Numbers and a Part description list and the boys were instructed to fill in the Alley Colour and Bin Numbers for the parts. On sheet 2 of the workbook is the current parts in stock. Some of the more astute of you will notice that the location of parts is... well haphazard to say the best, but as all young enterprising lads are often heard to say " we're a little busy right now but we plan on resorting the shed at the next available opportunity. Perhaps in the wet season. They've heard that George a local cocky is soon going to be putting in an order for spare parts and the boys need to both find the parts and be able to correctly invoice George.
On sheet 1 of the Accountant's workbook is a small 4 cell range with dropdowns relevant to the header for each dropdown, The experienced accountant Paul wants the ability to simply enter in the Part Number and the other three cells are automatically filled in with the correct data, where as Jake would rather simply enter in the Part Description and have the other cell completed, and Zack ... well he's got a rough idea where the part could be and is willing to go along with Jake's Idea.
Can anyone write some code to enable either method to be used please?