Hi guys,
I have two sets of data which I need to sort in a peculiar way.
Data Removed Spreadsheet Test.xlsx
Now, hopefully this makes sense... but I need to have a function that will look up the value in column B - match it to column K - return value of column M
This is because in columns D to H I need the amounts corresponding to the type of code.
i.e. cell B2 is INDE which from the table on the right (column K onward) is a "Employer Additional" amount - therefore the amount in C2 needs to go into Cell E2.
Does that make sense?
I've tried (without success) to use the Index Match functions as in; =INDEX(B2,MATCH(B2,K2:M182,0),3) - but I've never used these functions before (I'm a VLOOKUP addict) so I'm way off it seems haha.
Thanks, any help is appreciated.
Abid
Bookmarks