I work in the building industry and I'm trying to set up a spreadsheet to help my team work out measurements based on some drop down boxes, which pull data from the next sheet.
Sheet 1 has my table, column B has a drop down box with the suite selection, column C has another drop down box with a type, depending on the two of these the data varies. I have all the corresponding data in Sheet 2 for my drop down boxes and measurements to pull through but I cannot figure out how to pull those measurements through.
I have attached my spreadsheet so far but hoping there is a way to do this, I have been googling for days and don't think either VLOOKUP or HLOOKUP is the way to go.
Thanks in advance, I look forward to learning more!