"snake" wrote:
... =VLOOKUP(Day+E9;B1;2;"FALSE")
B1=TBL_one ......didn't work

You need to use INDIRECT ..

Try this: =VLOOKUP(day+E9,INDIRECT(B1),2,0)
where B1 contains: TBL_one

Or, with commas replaced by semicolons to suit your settings:
=VLOOKUP(day+E9;INDIRECT(B1);2;0)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--