Forum Discussion
Best way to do a Lookup on a variable date range
Hello what's the best formula to lookup a price based on dispatch date, customer code and item code based on another price file sheet with a variable pricing period? in pics below- i want to ...
Hi thanks Hans, This formula didn't work for me, I must be doing something wrong in the formula above and have reattached my new sheet.
Can i just match Column O2 in 'Masterdata' to lookup from column 'F' in 'Pricefile' and return if found the price in column 'G'?
I'm just unsure if I'm wording that right above
Take a good look at your formula. It is not the same as the formula that I posted.