Hello All i have inhherited (apparently i volunteered) a complex spreadsheet reporting metrics of test yield results. I have now been asked to seperate the metrics from one report into two reports Pumps and Valves.
I could add a column with a drop down list with the two options "Pumps and Valves" but i am unsure how to write what i guess would be a VLOOKUP formula to seperate the two results?
I guess it would then be best to create seperate worksheets for the two items?
Is anybody able to help me out please?
Bookmarks