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.