Thread: 2-Dim Lookup
View Single Post
  #1   Report Post  
Jeff Spiccoli
 
Posts: n/a
Default 2-Dim Lookup

Hi,

I've been using VLookup and it works well. But now I'd like Excel to choose
the cell that matches both the vertical and horizontal indexes. IE I'd like
it to choose the formula or value that is, say, below the value 3 (HLookup)
AND to the right of value 51 (as VLookup).

Can anyone help me?

Thanks in advance.

Jeff