How to increase cell address after getting the address from another function

[vpk304]

RoleNumber1	Value1
	Value2
	Total1
RoleNumber2	Value3
	Value4
	Total2
RoleNumber3	Value5
	Value6
	Total3

I have a table like above I need to query this sheet in a new sheet(Pre-filled with RoleNumber like in table 2) I need to search RoleNumber2 first and get the total of that RoleNumber.
Basically, let's say I search for RoleNumber2 with the following query sumif(Table1!$A:$A,$A1,Table!$B:B)) it will return Value3 which is in B4 in table 1 but i need "B4+2"'s value
Note: RoleNumber is unique
Is that possible? Can anyone please help me in this?

Name2
Name1
Name3

 

[vpk304]

Tried something on my one it worked for my case please let me know If i can simplifies
=IFERROR(INDIRECT(ADDRESS((MATCH(A1,Table1!A:A,0)+3),2,,,"Sheetname")),0)

 

[StephenCrump]

Welcome to the Forum!

Will this work for you?

	A	B	C	D	E
1	RoleNumber1	2
2		3		RoleNumber2	18
3		5
4	RoleNumber2	7
5		11
6		18
7	RoleNumber3	13
8		17
9		30
Sheet2

Cell Formulas
Range	Formula
E2	E2	=INDEX(B:B,MATCH(D2,A:A,)+2)
B3,B9,B6	B3	=SUM(B1:B2)

 

[vpk304]

Yes this worked thanks StephenCrump