Complex Look-Up Table

[Scorched_Soul]

Hi,

I'm having a bit of trouble creating a look-up table in Excel. I think the best way to explain this is with the attached file, basically what I'm trying to do is write a formula in sheet 2 that identifies in which column in sheet 1 the relative letter is located for each row. (If that makes sense?)

I've managed to do it if the options are "A", "B" or "A+B" using a combination of the INDEX and MATCH functions but struggled with the inclusion of the third variable. Is there any easier way to do it?

Thanks for any help or info you can provide,

[TheExcelphile]

Hi there!
Welcome to the forum

Here is the solution to your problem.

Don't forget to click the little star to the left of this post if you feel I helped!

[Scorched_Soul]

That's brilliant,

Thanks for your help.