Oct 14 2021 06:44 AM
Oct 14 2021 08:00 AM
Let's say you have a lookup list in R2:T50, with item names in column R, the corresponding price per day in column S and the price per acre in column T.
In D1: =IFERROR(B1*VLOOKUP(A1,$R$2:$T$50,2,FALSE)+C1*VLOOKUP(A1,$R$2:$T$50,3,FALSE),"")
This can be filled down if required.
Oct 15 2021 11:26 PM