Dear All,
I have one GL Code name 41110000 and so on at one place. I have series of GL Code at another place with columns and values therein. I need formula where 41110000 GL Code is searched in the series of GL Codes and place sum values of columns corresponding to the same GL e.g. is given below.
41110000 - sum = 24000
41120000 - sum = 1700
Series
column A column B
42033200 150000 20000
41100000 8000 300
41110000 20000 4000
41120000 1500 200
42020100 30 400
Thanks in advance.
Bookmarks