Hi
I would appreciate some help to set up a type Lookup formula.
The document contains prices for pumps parts. Column A has the pump model, Column B has the unique part codes (each pump model has a list of parts that fit into it) . In Row 2 you have the different regions the prices come from, and below that in Row 3 you have the customers names. Each Column under the customer name has the price they pay for the specific parts
I need a formula that would allow us to search by part, or by pump model (showing all relevant part associated with that pump model) and show next to the result the lowest price in the data for that part, the highest as well as the average. We would also like to be able to select by which region it should be searched.
I am not sure if you can have a Vlookup combined with an average, highest and lowest formula.
Please help
Thanks
Kind Regards
Gerhard
Bookmarks