FFS. I just can't get my head around this bastard formula.
Pretty sure I've done it before or similar using VLOOKUP and OFFSET or INDEX or summot.
Basically if you look at the attached sheet, all I want to do it populate the cells in the yellow and blue boxes (Column N) with the values in column G. First checking column A to see it matches column L and then checking colume B with column M.
So where it says B then T06 it will return 1000
Or where it says H then T44 it will return 27000
Anyone help me out?
DJ OD
Social Networking Bookmarks