Thread: lookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.