Forum Discussion
adding information to nested if formula not working
Thanks very much this returned the required reference's. Before the formula looks at these calculations is there anyway it could first eliminate the following fields IF(B2=3001,"N/A",IF(C2="IN","GEXPBOOK",IF(E2="GDG","GDG",IF(D2=1,"G1LINE") and then do the weight and volume calculations as you have done above. I think its the order that i'm asking excel to work out the calculation is wrong.
Im sorry I know i'm hard work I haven't used Excel for a long time. Thanks
I've put those additional conditions in; I'll leave it to you to verify that it's working correctly.
- Thanks mathetes it worked really appreciate all your help
Great solution, Matt (so long as all the columns in the data table cooperate).
I often suggest tables and VLOOKUPs as alternatives to multiple levels of IF. I've never seen MATCH(INDEX nested within VLOOKUP, but I like it and am filing that away for comparable situations.
Decades ago (literally) I nested an HLOOKUP within a VLOOKUP ... using at the time Lotus 1-2-3, if that's an indication of the time; I think it was in the early 1980s.
- yes, for some reason the VLOOKUP - MATCH seemed to make more sense. The final INDEX inside was just to index the named range instead of having another range or name.
