I have a table of several columns
Column A client code
Column B outstanding loan amount
column c type of loan numeric code
I have a list of client codes, and want to vlookup the code and sumif the loans referred to that client in a particular loan code.