Hi all,
Looking for any wizards out there who can help me build some formulas to try to achieve the below described goals for my attached excel file.
Any help, advice, or direction would be greatly appreciated!
Goals:
Return value in column H from "PRL1A PRL2A PART NUMBER DATA" sheet to cell L4 on "PANEL BUILDER" sheet.
Return value in column I from "PRL1A PRL2A PART NUMBER DATA" sheet to cell M4 on "PANEL BUILDER" sheet.
Return value in column J OR K from "PRL1A PRL2A PART NUMBER DATA" sheet to cell N4 on "PANEL BUILDER" sheet.
Variables:
Variables to determine returned values in column H & I ("PRL1A PRL2A PART NUMBER DATA" sheet) to be controlled by cell dropdowns A3 through G3 ("PANEL BUILDER" sheet). Equivalent Array data for these drop downs to reference are in the same order on the "PRL1A PRL2A PART NUMBER DATA" sheet columns A through G.
The variables to determine returned values in column J OR K ("PRL1A PRL2A PART NUMBER DATA" sheet) is controlled by the dropdown variable in H3 ("PANEL BUILDER" sheet). EG. If H3 is "SURFACE" data to be returned from column J ("PRL1A PRL2A PART NUMBER DATA") If H3 is "FLUSH" data to be returned from column K ("PRL1A PRL2A PART NUMBER DATA").
Bookmarks