I have 2 Sheets named as Sheet1 and Sheet2...
Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column.
Sheet2: Contains 2 Columns. Based on Column 1 Id It needs to get the open price from Sheet 1 and should be shown in column 2 of Sheet 2...
Note: I don't want to modify sheet1 and 2 in any way... Please don't add any additional column in sheet1 and 2...Using that I can achieve the result...
Without modifying any criteria I need to get the result cause I will be retrieving past data and will do some complex operations on that...
link Sheets