Sum multiple returns on lookup

[nvboelens]

Dear all,

I'm having a problem regarding the following: I'm trying to look-up values in a sheet and to return a value that corresponds with that value. For example see the image. For example, A1002 can be done with the INDEX MATCH combination. However, this function only returns one value. If we look to A1003, this function only returns the first value (6), but I want the SUM of both the values (6+1 for A1003 or 7+4 for B2004).

Is there a way to do this within Excel? Let me know, it would save me a ton of work!

Thanks in advance.

 

[alansidman]

No viewable image.

 

[nvboelens]

I'm sorry. Here is the image that should have showed up.

 

[alansidman]

Still no image. Suggest you approach this in a different manner

 

[Fluff]

@nvboelens
This site does not allow for uploading images, however there are some add-ins available here https://www.mrexcel.com/forum/about-board/508133-attachments.html that will allow you to post sample data in your posts.

 

[FormR]

but I want the SUM of both the values (6+1 for A1003 or 7+4 for B2004).

Hi, from your description, it sounds like you want the SUMIFS() formula - for example:

Excel 2013/2016
	A	B	C	D	E
1	A1004	7		A1003	7
2	A1002	9
3	A1003	6
4	A1002	5
5	A1003	1
6	A1005	10
7	A1004	4
Sheet1

Cell Formulas
Range	Formula
E1	=SUMIFS(B:B,A:A,D1)

 

[DanteAmor]

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

Or simply describe how your data is on the sheet.
You can copy the range of cells and paste here, it will not look like excel but it will give us an idea.

 

[nvboelens]

Holy, how could I've missed this. Works like a charm!

Thanks for replying everyone.