Forum Discussion

Abi Black's avatar
Abi Black
Copper Contributor
Jun 05, 2018

Excel Help

I have a row with 4 cells with text value ("L" or "H"). I want a formula that can compare the combination of letters in one row of 4 cells to a table on the 2nd tab. The table has different combinati...
Formulas & Functions
Need Help
Abi Black's avatar
Abi Black
Copper Contributor
Jun 05, 2018
Yes it looks like it, please can you share the formula?
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jun 05, 2018
    Yes it's in the file I attached. I used & to join all 4 letters into 1 cell and then did a lookup on that value in the other table.

    I used INDEX MATCH for the lookup. The MATCH part works out which row has a match, then the INDEX part brings back the corresponding Name from that row.
    • Abi Black's avatar
      Abi Black
      Copper Contributor
      Jun 05, 2018
      Thanks - just thinking the sequence of the letters will be random so I need the formula to work with any sequence. Can you help?
      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Jun 05, 2018
        Hi Abi

        I don't really understand what you mean sorry. Can you give me an example / more explanation

Resources