Oct 07 2019 02:23 PM
I have a drop down created on sheet 1 and need the sheet to populate data from sheet 2 based upon which drop down is selected from sheet 1. I know each data cell needs a formula to first reference the drop down cell to understand which site to look at and from there which data value to pull from sheet 2, but I'm unfamiliar with the string formula process. Thanks in advance.
Oct 07 2019 05:07 PM