Extra Cost_Code Description2 Total_Estimate
357911410 09-7500 Kitchen - L1 Cabinets 930
357911435 09-7500 Kitchen - Upgrade Hardware 138
357911450 09-7500 Kitchen CountertopsBacksplash -700
357911450 09-7600 Kitchen CountertopsBacksplash 2570
357911615 15-4000 Kitchen Single Bowl Sink 60
357911630 15-4000 Kitchen L1 Faucet Classic Stai 150
I have the above data in an excel spreadsheet. You will see how the extras numbers repeat and the cost code numbers repeat. I need a nested IF
statement or a nested VLOOKUP
statement that says:
if extra = # AND Cost Code = # then display Total Estimate
I'm screwing up my VLOOKUP
statements and it's showing me 35711450 and 09-7500 twice instead of 35711450 and 09-7500 and on the next line 35711450 and 09-7600 , which would result in -700 and 2570
Help. THANKS!
Aucun commentaire:
Enregistrer un commentaire