I have a spreadsheet that where I input data for pH and EC (electrical conductivity) readings for potted plants. The CropData tab has all of the raw data. On the PTDash tab, I want to be able to select the year, week number, zone and crop via drop down menus (which I already have set up) and have it return the data for those filtered items in one table.
I'm at a loss as to whether to start with a XLOOKUP formula or a FILTER formula (or something completely different) and how best to get it to display the corresponding data in each column.
I also need it to average the pH and the EC numbers in the space provided at the top. I think I can figure that out once I have the rest set up, but assistance on that would be helpful as well.
Sample spreadsheet is attached. There are a few hidden tabs in the attached, but I think I have unhidden all of the ones relevant to this dashboard that I'm trying to set up. Please let me know if you have any questions.
Bookmarks