lookup

[Guest]

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.

 

[Guest]

Not sure what you mean by domain?

What's in A1 and A2?

An example would help.

 

[CLR]

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

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.

 

[Guest]

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.