Forum Discussion
Complex (for me!) lookup formula - help please....
I need an Excel formula to return a lookup value based on date. The lookup dates and values (exchange rates for each date) are arranged in two columns per year. More detail in the spreadsheet attach...
Please try this:
=LET(in,XMATCH(YEAR(A19),$1:$1),XLOOKUP(A19,OFFSET($A$1,1,in-1,365),OFFSET($A$1,1,in,365)))
Please try this:
=LET(in,XMATCH(YEAR(A19),$1:$1),XLOOKUP(A19,OFFSET($A$1,1,in-1,365),OFFSET($A$1,1,in,365)))
- Sergei and dscheikey -
Both your solutions work beautifully.....but of course you knew that 🙂 !
Thank you so much for your lightening fast replies - much appreciated.
I will now hopefully learn how your solutions work as I adapt them to my live data.
Cheers
Mike
