Why is my index match formula not working to return the values I expect from a list

please see attached spreadsheet
Thanks Carroll

You really need to describe what your problem is or what you're looking for AND ...

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

There is no file attachment. Suggest you try again uploading.

Sadly, there is no attachment ... hence me asking for one and describing how to upload it.

Not everyone wants to download a workbook in order to look at your requirements. But, right now, they can't do that if they do want to.

And, in fact, if you included your formula in the post, someone might immediately spot what's wrong with it.

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

deleted

OOPS, sorry, no admin note was posted when I hit reply.

Change the 3rd element of the MATCH function to False or 0

Although why use Index(Match()) when in this case a straightforward VLOOKUP() is sufficient?

Ali,

Why have you deleted my post?

It was quite clear to me that the OP was looking for help with an INDEX Match formula. How much more explicit do they have to be?
Why did you not discuss it with me first?

Note: now reinstated following title adjustment.

Thread titles, as explained in my post, should not just be a function name without an indication of what the OP is trying to do with it.

All participants: Until the OP gives a more detailed thread title, there should be no further posts to this thread.

Thank you.

Carroll - please address the thread title issue. Thank you.

Hi Carroll,

As has been pointed out in posts #9 & #14 it's the 3rd element of the match function that's wrong. It should be False or the equivalent 0

i.e.

Formula:

Please Login or Register  to view this content.

...but as I said in #9, why use two functions, index and match when the single vlookup function is all you need in this case.

Try this:

=IFERROR(VLOOKUP(A7,$G$6:$H$23,2,0),0)

I'm Ali, not Richard,

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