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)
|