Hey guys,
I need some help in creating a formula that will pull a stock price from a data table when I select a company and a date. The formula I am using right is not working and I don't quite know why.
Attached is what I'm working with. and the formula that is currently being used is
=IFERROR(INDEX(DATA!B5:S65,MATCH(LookupSheet!C2,Company,0),MATCH(LookupSheet!C3,Date,0)),"Select Variables")
Also I need to be able to return the cell above the original cell in a separate equation. I'm pulling these stock prices to put into an equation that will need a beginning stock price and an end one.
Let me know what you guys think and if you could give me some tips that would be greatly appreciated. Thanks!
I need some help in creating a formula that will pull a stock price from a data table when I select a company and a date. The formula I am using right is not working and I don't quite know why.
Attached is what I'm working with. and the formula that is currently being used is
=IFERROR(INDEX(DATA!B5:S65,MATCH(LookupSheet!C2,Company,0),MATCH(LookupSheet!C3,Date,0)),"Select Variables")
Also I need to be able to return the cell above the original cell in a separate equation. I'm pulling these stock prices to put into an equation that will need a beginning stock price and an end one.
Let me know what you guys think and if you could give me some tips that would be greatly appreciated. Thanks!