Need Help with Index and Match Formula

**aalim95** · 08-29-2013, 03:31 PM

As you can see in the file. Cell A19 has the result. Cells D19 and E19 are the drop down lists from the ranges from A5:A13 and B5:B13. I tried using the index and match formulas to give me the result, that is the Unique Code.

Problem: Whenever I choose the Item and 1000 counts in D19 and E19 the result in A19 is an error. However whenever I choose the Item and 100 counts in D19 and E19 the result comes out fine.

Can anyone tell me what the problem is? What I am doing wrong? I am getting so frustrated!! Please HELP!!!

Thanks in advance!!!

I have also attached the file for your convenience.

**Fotis1991** · 08-29-2013, 03:38 PM

Try your formula like this.

=INDEX(C5:C13,MATCH(D19&E19,A5:A13&B5:B13,0))

This is an ARRAY entered formula.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.

**aalim95** · 08-29-2013, 03:45 PM

THANKS SOOOO MUCH !!!!!!!!!!!!!!!

I HAD NO IDEA THAT ARRAY FORMULA NEEDED CTRL+sHIFT+ENTER

THIS WILL HELP ME A LOT!

IT'S WORKING AWESOME!!!!!!!

**Fotis1991** · 08-29-2013, 03:51 PM

You are welcome and thanks for the feed back.

Need Help with Index and Match Formula

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need Help with Index and Match Formula

Re: Need Help with Index and Match Formula

Re: Need Help with Index and Match Formula

Re: Need Help with Index and Match Formula

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenated INDEX MATCH formula that won't give error that can index match 2-4 strings

Index Match Index Formula work slow

Index/Match/Match. Formula looking veritcal and horizontal headings to find a match

Nested Match(index()) vs. Match() array formula.

[SOLVED] How do I display more than one match in a Index/Match formula?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions