Index Indirect MAtch

[Cherryl]

The below formula returns an incorrect match. I am trying to create a drop down option for each table of data, but it returns a match even when it shouldn't

=INDEX(INDIRECT(A2&"[PTP Edit Rationale]"),MATCH(A4&"|"&B4,(INDIRECT(A2&"[Pair]",0))))

[ChemistB]

Hard to tell without a workbook to reference. Create a short dummy workbook and upload as per the instructions in yellow at the top of the page. When you say it returns a match, what sort of match? Any pattern like off by 1? Again, an example would clarify all of this.

[Kaper]

Please read the yellow banner at the top of the page. Or skip to extended version of it below:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, etc. - please show them all, or at least indicate in text). The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following (paperclip icon does not work!): Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[Cherryl]

Capture.JPG

I would like to be able to select a table from the drop down, and get a matching description for a pair of codes from that table.
But my formula gives me a description even when the cells for the codes are blank or the codes I enter is not from the table I selected.

[JeteMc]

The following formula seems to work:

Please Login or Register  to view this content.

Note that Table2 needs to be resized.
Let us know if you have any questions.

[Cherryl]

This worked perfectly. Thank you so much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.