hi harlan ,
i have seen so many questions about vlooku and concatenate function and they
suggested to use indirect or use pull funciton created by you,
can you redefine your macro as per my requirement please , as i ma not that
good with vba codes.

Thanks
please reply i will send you my excel data.

"Harlan Grove" wrote:

sjring wrote...
....
Each individual asset's worksheet is layed out identically, with the
database I'm searching in the range B14:D109.
....
=VLOOKUP($G$8,CONCATENATE(ADDRESS(14,2,1,3,TEXT($ D9,"0")),":$D$109"),1,FALSE)

The cell is returning a #Value error, I suspect because the
concatenate
function is returning a string and not a cell range. Any ideas on how
I can
vary the sheet name based on the value in cell D9?

Don't screw around with either CONCATENATE or ADDRESS. Use
=VLOOKUP($G$8,INDIRECT("'"TEXT($D9,"0")&"'!B14:D10 9"),1,0)