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?
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?