I have named 2 leaves as leaf 1 and leaf 2 …
Sheet 1: Contains drop-down list for column B4. Based on the selection of the item, the result of the open price displayed in column D4 is retrieved.
Sheet 2: Contains 2 columns.
Based on column 1 ID The open price of sheet 1 must be retrieved and should be displayed in column 2 of sheet 2 …
Note: I do not want to change Sheet1 and 2 in any way. Please do not add extra columns in Sheet1 and 2. That way I can achieve the result.
I do not have to change any criteria to get the result because I'll retrieve past data and do some complex operations.