INDEX and MATCH with range LOOKUPs?

Hi Guys,

Would it be possible to combine INDEX and MATCH with range LOOKUPs?

I've attached an example file.

Thanks a lot.!

Thank you for this one. really appreciate it.

Just have one quick follow up question. What if i wanted to include the Name as a criteria?

Originally Posted by NBVC

Try naming each table.

Select A4:C8 and in the Name Box (left of Formula Bar) enter: LVL1

repeat for each table.

Then use formula:

=LOOKUP(H5,INDEX(INDIRECT(G5),0,2),INDEX(INDIRECT(G5),0,1))

copied down.

No worries. I think the one you have provided will do.

I have another follow up. (sorry for the hassle) what if im gonna add another set of ranges. I have a file attached.

Thank you for the help.

Originally Posted by NBVC

In what way? How will the tables be set up?

So you want the formula to decide which table to return result of? - YES sir.

Can you provide the logic that the new formula is supposed to satisfy? - Basically the logic is just to lookup a given score's final score based on its per level ranges.

Originally Posted by NBVC

So you want the formula to decide which table to return result of?

Can you provide the logic that the new formula is supposed to satisfy?

Hi,

Thank you for the option. But what i mean is that well have different "Final Score" for each Raw Score basing with the Lvl as well.

1. Final Score 1 should reflect scores based on the LVL and Ranges Column. ( based on Raw Score 1 only).
2. Final Score 2 should reflect scores based on the LVL and Ranges Coulmn. (based on Raw Score 2 only).

Here's an attachment.

Thank you.

Originally Posted by NBVC

Not sure if that answers my question.. but anyways..maybe try this.

Rename each Table something like this: LVL1RawScore1 (no spaces)

Then use formula in N16:

Please Login or Register  to view this content.

copied down

Is that what you mean?

Hi,

It's all good now. I just managed to twist on the tables (ranges) to be placed. Your last recommendation is awesome!!

Thanks YOU

Originally Posted by neilbomb

Hi,

Thank you for the option. But what i mean is that well have different "Final Score" for each Raw Score basing with the Lvl as well.

1. Final Score 1 should reflect scores based on the LVL and Ranges Column. ( based on Raw Score 1 only).
2. Final Score 2 should reflect scores based on the LVL and Ranges Coulmn. (based on Raw Score 2 only).

Here's an attachment.

Thank you.