Help with Indirect Function

Hi, I have a formula that looks like this :

I cannot post links or images.... it is a formula, not a link or image but it will not let me post it.

The column reference at - tier_tbl[LOLB]

I would like to make this dynamic as this value LOLB changes and can be many other values depending on user choices. The value LOLB or any other it might be is always contained at cell G2. If I put formula =Indirect("G2") it produces LOLB as it should but I'm having trouble getting it into the index match formula and is generating errors. Does anyone know how I can correct this formula, I'm at a loss.

Rayburn

The formula is as follows: INDEX(tier_tbl[Tier],MATCH([There is an at symbol here that i think has been preventing me from posting[Percent_Rank]],tier_tbl[LOLB],1))

Hopefully this goes through but the column reference at tier_tbl[LOLB] is what I am trying to make dynamic so it's just not hard coded because it can 20 other columns as well based on user input.

That input is stored in cell G2, so I thought I could just use Indirect on G2 which =Indirect("G2") does produce LOLB as intended but as I put it in the big formula, I get errors.

Rayburn

It's ok I finally figured it out, the formula should be:
IFERROR(INDEX(tier_tbl[Tier],MATCH([at symbol[Percent_Rank]],INDIRECT("tier_tbl["&$G$2&"]"),1)),"")

This took care of it, thanks for replying though.

Rayburn