A1 and A2 are user selected fields, probably drop down lists. A1 would
reference the desired row and A2 would reference the column, or vice versa.

Example:

vlookup(A1,H1:X35,3,False) looks up A1 from the row names in the grid H1:X35
and selects the value in the third column of that row. I want to look up A1
in the row names of the grid H1:X35 AND look up A2 in the column names and
return the value in the (A1,A2) cell.

"Toppers" wrote:

Not sure what you mean by domain?

What's in A1 and A2?

An example would help.

"Matt" wrote:

is there a function that combines vlookup and hlookup? i would like a
formula that reads something like xlookup(A1,H1:X35,A2,False). the idea is
to reference the value in a cell for the domain and range in the same line.