Forum Discussion
Help - What's the best forumla for a lookup between 2 dates based on a product code?
I was wondering if someone could help - need help with a forumla I need to return a price for the product code in colmn E below (possibly with a lookup), from the sheet 'PricefileLookup' belo...
In R2:
=IFERROR(INDEX(PriceFileLookup!$D$2:$D$10000, MATCH(A2, IF(PriceFileLookup!$C$2:C$10000=E2,PriceFileLookup!$A$2:$A$10000))),"")
If you do not have Microsoft 365 or Office 2021, confirm by pressing Ctrl+Shift+Enter.
Fill down.