lookup
 

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.

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.

lookup
 

What you have given as an example can be used as a legitimate VLOOKUP
formula, providing A2 conatains a number between 1-17. The cell you find,
"could" contain a HLOOKUP formula if you wished...........

hth
Vaya con Dios,
Chuck, CABGx3


"Matt" wrote in message
...
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.

lookup
 

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.