Is it possible to add a second sheet to the design table? This sheet would contain tables that would be referenced using vlookup from sheet 1.
And here is an example
You can cut and paste the design table on sheet 2.
Select the BOM table, press ctrl +X (cut), go to next sheet and press ctrl + v (paste).
Awesome! Thanks everybody. Mike, that is exactly what I wanted to know, thanks.
Retrieving data ...