I have a table with product names as column headers and vendors as row headers. The body of the table is populated with product costs for each vendor. I want to create a second table with products as row headers and price leader / Price as column headers. The idea would be for the formula to use the row header from the second table to identify the column it should look at from the first table and find the cheapest price (and the vendor that sells at that price).
I've included a copy of my data for reference purposes.
Thanks in advance
Bruce
P1 Excel raw data file.xlsx
Bookmarks