View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Reference cell in one TAB from another using two criteria

I would like to reference a cell in TAB A based on two criteria,

Where
Named_Range_Date = A1

and

Named_Range_Hour = B3

I need to be able to copy this formula so that I can populate a new table,
any ideas?
--
Jeff