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
.