J

#### joemeshuggah

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

is there a way to accomplish this?