index match formula

Hi expert's excel 2007

I need an index match formula to add 3 index matches together if the lookup is. Not in the table then do not return #n/a but ""...

so =ifserror(index(range,match(vertical,match(horizontal)) +index(range,match(vertical,match(horizontal)) +index(range,match(vertical,match(horizontal)),"")))

Something like this....is what i am using but cannot get it to work.
route217Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

Do you mean this ?
=IFERROR(INDEX(J:J,MATCH(B1,C:C,0)) +INDEX(G:G,MATCH(B1,D:D,0)) +INDEX(F:F,MATCH(B1,H:H,0)),"")

Open in new window

REgards
0
 
route217Author Commented:
Hi Rgonzo1971

would ur formula work...that what I am looking for...but the inly difference is my formula to reference one table and add three names to sum up into one overall value..
0
 
Rgonzo1971Commented:
HI,

Could you b more specific?

Regards
0
 
route217Author Commented:
Worked it out ....thanks fir the pointers
0
All Courses

From novice to tech pro — start learning today.