Issue with INDEX&MATCH formula not pulling through multiple values

Dear all,

I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective.

Currently, I have the following (please ignore column B, D and E and everything but cell C1 in column C.

Snip1.PNG

The formula pulls data from this master data sheet, called "Test data transposed":

Snip2.PNG

My issue is currently that the formula only works for the first value, I.E. cell F2. Once I pull it down to cell F8 it just leaves cells F3-F8 blank.

Can anybody help me fix this so the values in F3-F8 return the correct values?

Apologies for any confusion - please feel free to ask questions and ask me for more data or screenshots as well!

Kind regards,
Jyggalag

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

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. As you are new, I have done it for you today.)

There are instructions at the top of the page explaining how to attach your sample workbook.

By the way, I see merged cells. This is a BIG NO-NO!!! Satan's spawn - get rid of them.

Remove answer by menem

@menem

Why did you remove your suggestion?

I'm think that OP may need to do somthing that is not optional, (I don't want to go infractions again. // I'm not sure about
english so, I'm afraid 'not optional' word. T_T.


Regards.

To ALL participants

If you read my post PROPERLY, you will see that I said this:

(Note: this change is not optional. As you are new, I have done it for you today.)

The OP is new here, so I have amended the title for him/her.

Oh!. seem I misunderstood again. Sorry.

Dear Jyggalag

my suggestion is.

please check,

INDEX( range , row , column ) NOT INDEX( range , column , row )

Regards.

Why not attach a workbook, as I suggested? It would make this easier for everyone. See post #2 (which you clearly still haven't fully read).

When are you going to read the whole of post #2? I have told you already where the instructions are ...

Please read the whole of post #2. I'll bet you haven't yet read my comment about merged cells ...