# Lookup GL Code at another place and sum for that GL

1. ## Lookup GL Code at another place and sum for that GL

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  Register To Reply

2. ## Re: Lookup GL Code at another place and sum for that GL

Try this: ...............  Register To Reply

3. ## Re: Lookup GL Code at another place and sum for that GL

Try this:

Excel 2016 (Windows) 32 bit
[COLOR="rgb(255, 255, 255)"] [/COLOR]
[COLOR="rgb(255, 255, 255)"]A[/COLOR]
[COLOR="rgb(255, 255, 255)"]B[/COLOR]
[COLOR="rgb(255, 255, 255)"]C[/COLOR]
[COLOR="rgb(255, 255, 255)"]1[/COLOR]
42033200
150000
20000
[COLOR="rgb(255, 255, 255)"]2[/COLOR]
41100000
8000
300
[COLOR="rgb(255, 255, 255)"]3[/COLOR]
41110000
20000
4000
[COLOR="rgb(255, 255, 255)"]4[/COLOR]
41120000
1500
200
[COLOR="rgb(255, 255, 255)"]5[/COLOR]
42020100
30
400
 Sheet: Sheet1

Excel 2016 (Windows) 32 bit
[COLOR="rgb(255, 255, 255)"] [/COLOR]
[COLOR="rgb(255, 255, 255)"]F[/COLOR]
[COLOR="rgb(255, 255, 255)"]1[/COLOR]
=SUMPRODUCT([COLOR="rgb(255"]([COLOR=" 0"]A1:A5=E1[/COLOR])*([COLOR=" 0"]B1:C5[/COLOR])[/COLOR])
 Sheet: Sheet1  Register To Reply

4. ## Re: Lookup GL Code at another place and sum for that GL

Sorry my Forum Tools add-in seems not to be working!

With 41110000 in E1, this in F1:

=SUMPRODUCT((A1:A5=E1)*(B1:C5))  Register To Reply

5. ## Re: Lookup GL Code at another place and sum for that GL

Thanks a lot. Resolved the problem.  Register To Reply

6. ## Re: Lookup GL Code at another place and sum for that GL

You're welcome!   Register To Reply