i am looking to have a specific spreadsheet reference a second sheet that is
variable daily in both rows and columns...a vlookup takes care of the rows,
but since the number of columns and/or column order may change, i cannot
hardcode the column index number in the vlookup formula.


i thought i could use a vlookup formula where the column referenced is based
on a column and hlookup function...i tried the following, but received an
error message:

=vlookup(a2,myrange,column(hlookup(b1,myrange,1,fa lse)),false)

is there a way to accomplish this?