Hello - Running into a head scratcher here. it seems easy but I am having trouble putting all the pieces together and hoping someone could help. I condensed my large data set into one tab for ease as a sample
I have VBA code that will run 1 days worth of data if B11 = B12
If B11 doesnt equal B12 then it will run for 2 sets of dates; once for B11 and once for B12. So duplicates will generate.
Formula I am looking for is to lookup the price of a identifer where if C is blank it uses B11 as the date to lookup and if C has a value it uses B12 as a lookup
I can rearrange A:D to make the lookup easier. Any help is appreciated my dataset is 1,000 lines so manual approach is exhaustive. I am open for VBA or a formula. Thanks in advance.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.