thanks, i just worked this out what I done wrong about a minute before got the subscription email telling me you replied. thanks for all your help
the formula that seems to work i settled with is
Quote:
|
=VLOOKUP(P2,INDIRECT("'[2015 Cordell Valuation Lookup Tables.xlsx]"&BK2&"'!$A:$I"),5,FALSE)
|
I realised that the indirect wasnt closed properly.
I'm still wondering what part the & sign plays on the BK2 reference. I've never seen it before? what does that do when I use it? or is it something purely for indirect?