need some help with google sheets
- Let's say I have a stock ticker in cell A1, let's say ACN/ NYSE:ACN
- Let's assume I have a random price - 370.46/370 in cell B1
- I want cell c1 to use the info in cell A1 and B1, and pull the date on which the stock hit that price
I want to be able to edit cell b1 with various prices and I want a formula that's able to pull up the date on which it hit that price
haven't been able to find a formula to do that