Google-sheets – Indirect formula to add table field to vlookup formula

formulasgoogle sheetsvlookup

So I have to get a price based 3 variables
Diamond size
Diamond quality
Diamond Shape

So I made tables depending on shapes

This formula is working
Diamond size = H11 = 1
Diamond quality = $K$3 =3
Diamond Shape = 'DIAMOND PRICES '!$A$64:$F$103

=VLOOKUP(H11,'DIAMOND PRICES '!$A$64:$F$103,$K$3,FALSE) = correct answer 600

So Move on to add the diamond table variable
I get the answer
G11 = 'DIAMOND PRICES '!$A$64:$F$103

=VLOOKUP(H11,(indirect(G11)),$K$3,FALSE) – #REF!
Reads it correctly but I get this message :

Function INDIRECT parameter 1 value is 'DIAMOND PRICES '!$A$64:$F$103'. It is not a valid cell/range reference.

The only difference I can see is the ' at the end so not sure why it is there, or why the formula is not working or reading the formula correctly.

Best Answer

Remove the single quotes around DIAMOND PRICES.