vendredi 27 octobre 2017

Nested nested nested IF statements in Excel

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