Variable range name in vlookup

[jaspe709]

I am trying to use a variable in vlookup for the Table Array.

I used the formula shown below.

Formula in G8
=VLOOKUP($F8,E8,G$6,FALSE)

The cells indicated below contain the formula above, the result of the formula is shown, and the range name that is indicated in the cell.

E8 G8
Current_AR #N/A

Is there a way to use a variable for the table array?

 

[bryhamm]

If I understand your question correctly, you should change your formula to:

=VLOOKUP($F8,INDIRECT(E8),G$6,FALSE)

 

[jaspe709]

Thank you, it works.