Help needed with INDEX MATCH

[churmie]

Hi guys

I am trying to do an index match only some of the cells that I am matching against are in a merged cell. Would this make a difference?

Column B Column C

Forecast 5000
Sales 4800
Waste 4%
Availability 98%

So in the above, there would be an item code that runs down Column A that is in a merged cell which stretches down in juxtaposition with the measures Forecast, Sales, Waste & Availability. Can I get a formula that matches the item code and the measures in column B and give me the result from column C?

Thank you in advance! I have already lost a couple of hours on this!

Churmie

 

[Gerald Higgins]

Hard to say, partly because you haven't shown us what type of data is in column A, and I can't figure it out from your narrative.

If you're saying you have an item code in column A that refers to all 4 of those data lines, and then that is followed by another single item code in column A with another 4 lines of data, then setting up a formula to match the item code and then the measures can probably be done.

QUESTION - do all 4 items have EXACTLY the same 4 measures in column B, and in the same sequence ?
If yes, then you can probably do this using a combination of INDEX, MATCH, and perhaps OFFSET, or perhaps hardcoding the offset value within the INDEX function, depending on what exactly you want to do.

Can you clarify please ?

Don't worry about explaining the real world application of your problem, that's probably not too important, just focus on what data you have and what exactly you want to do with it.