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
Best Answer
paste in B2 cell on Sheet2: