lookup
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.
|