Forum Discussion
Need help with formula
Good morning, Looking to make a billing spreadsheet that will eliminate the need for manual entries. 1) I am looking to take the data from cell C3 and E3 on my "template" sheet, and compare i...
Hi Amanda,
To simplify your data structure as
the formula in L2 for the price will be
=IFERROR(INDEX($B$2:$G$7,MATCH($I2,$A$2:$A$7,0),MATCH($J2,$B$1:$G$1,0)),0)*K2
You may adjust to your actual ranges.
Attached
Thank you Sergei, this is exactly what I needed! Your help is greatly appreciated.
Amanda, you are welcome