Hi,
I have set up a matrix as follows:
Column H: Dates
Column I: Buy Rates (heading is “B”)
Column J: Sell Rates (heading is “S”)
In column A I have a list of dates and in column B the letter “B” or “S”. I am trying to create a formula in column C that will use the date in column A and the letter (“B” or “S”) in column B to return from the matrix the value of the buy/sell rate at a particular date.
Can someone please help?
Thanks!
Bookmarks