View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default HLOOKUP on Two Ranges

Hi,

I would like a formula please.
I have a table in cells c4:aa7.
I want to lookup the value in cell B10 where the table array is in
cells C4:AA5 and the row index number is 2.
But I also want it to lookup the same cell B10 in C6:AA7 with the same
row index 2 please.

Thanks in Advance.
All the Best.
Paul