Hi,
I have created a quotation format. In quotation work sheet, upon giving the inputs, the price is being taken from the next sheet name PRICE LIST. Will this quotation sheet works if the SHEET PRCE LIST is being kept separately. If this works, it would assist me to modify the price list remotely.
I have created a quotation format. In quotation work sheet, upon giving the inputs, the price is being taken from the next sheet name PRICE LIST. Will this quotation sheet works if the SHEET PRCE LIST is being kept separately. If this works, it would assist me to modify the price list remotely.
RTH PRICING SHEET-RUSKIN-01-08-2021.xlsx | |||||
---|---|---|---|---|---|
AC | AD | AE | |||
26 | DAMPER/BASE PRICE | STYLE MULTI | TOTAL DAMPER | ||
27 | 785 | 1.00 | 785 | ||
WORKSHEET |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AC27 | AC27 | =(INDEX(INDIRECT(O27&Q27&"A"),XMATCH(M27,INDIRECT(O27&Q27&"H"),1 ),XMATCH(L27,INDIRECT(O27&Q27&"W"),1 ))) |
AD27 | AD27 | =IFERROR(IF(OR($N27="FSD",$N27="SD",$N27="FD",$N27="CD"),INDEX('PRICE LIST'!$C$7338:$C$7653,MATCH(WORKSHEET!$O27&WORKSHEET!$P27,'PRICE LIST'!$A$7338:$A$7653&'PRICE LIST'!$B$7338:$B$7653,0)),0),"") |
AE27 | AE27 | =AC27*AD27 |
Press CTRL+SHIFT+ENTER to enter array formulas. |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
AD27 | Cell Value | =0 | text | NO |
AC27 | Cell Value | =0 | text | NO |
BS27,BM27:BQ27,BK27,BC27:BH27,AP27:AU27,AW27:AZ27,AE27:AF27,AH27:AL27,AE28:AE35 | Cell Value | =0 | text | NO |