First time poster here.

I have a formula that searches through 4 data ranges for a players rego number and returns a value (number of 180's thrown), if the player exists in more than one data range (A dart division) I am only getting the first value the formula finds and not several added together.

Is it possible to attach workbooks on this forum?

Forgive the cross post but I have an example workbook on Ozgrid. http://www.ozgrid.com/forum/showthread.php?t=166022

In the attached cut down workbook the example is for rego number 415 Gisborne Stanley, he has thrown 1 180 in Premier B and 3 180's in Division 2 but in the 180 register the total in column N is 1 and not 4.

=IF(NOT(ISNA(VLOOKUP(A4,PremA,10,0))),VLOOKUP(A4,PremA,10,0),IF(NOT(ISNA(VLOOKUP(A4,PremB,10,0))),VLOOKUP(A4,PremB,10,0),IF(NOT(ISNA(VLOOKUP(A4,_Div1,10,0))),VLOOKUP(A4,_Div1,10,0),IF(NOT(ISNA(VLOOKUP(A4,_Div2,10,0))),VLOOKUP(A4,_Div2,10,0),0))))

Could someone educate me as to the correct formula to use?