Forum Discussion
Solved
Help with Excel Formula to find the price based on industry and number of transactions
Hi All, Hope you are doing well!..I am trying to determine the price for my input table which has the specific industry type and the average monthly transactions based on the reference table 1 whi...
Change 10001+ in Input!M7 to 10001.
If you have Microsoft 365 or Office 2021, in C2:
=XLOOKUP(Output!A2,Input!$H$2:$H$4,Input!$I$2:$I$4)*0.9^(XMATCH(B2,Input!$M$2:$M$7,-1)-1)
If you have an older version:
=VLOOKUP(Output!A2,Input!$H$2:$I$4,2,FALSE)*0.9^(MATCH(B2,Input!$M$2:$M$7)-1)
Fill down.
Change 10001+ in Input!M7 to 10001.
If you have Microsoft 365 or Office 2021, in C2:
=XLOOKUP(Output!A2,Input!$H$2:$H$4,Input!$I$2:$I$4)*0.9^(XMATCH(B2,Input!$M$2:$M$7,-1)-1)
If you have an older version:
=VLOOKUP(Output!A2,Input!$H$2:$I$4,2,FALSE)*0.9^(MATCH(B2,Input!$M$2:$M$7)-1)
Fill down.