Hi All,
I am struggling in working out the best way to work this problem out so hoping for some guidance and help.
I have attached the spreadsheet that I need help with..
In each worksheet it shows numbers and a band number columnUK_Dial_Plan_01092012 Met-lookup.xlsx, I want to each worksheet to look at the charge band coloum and check the associated cost of that charge band which is in "Charge Costs" section
i think it requires a VLOOKUP and an IF statement but as I dont use excel all the time I could do with some pointers on this one
Any help would be greatly appreciated
Thanks
Bookmarks