Solved

index match formula

Posted on 2014-01-20
4
298 Views
Last Modified: 2014-01-21
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.
0
Comment
Question by:route217
  • 2
  • 2
4 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39796203
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
 

Author Comment

by:route217
ID: 39796217
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
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 39796244
HI,

Could you b more specific?

Regards
0
 

Author Comment

by:route217
ID: 39796305
Worked it out ....thanks fir the pointers
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now