View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Reference cell in one TAB from another using two criteria

Think your intents were not specified,
ie to do what?? where the dual criteria is met

Try something along these lines, depending on your intents ..

To Count # of instances where the criteria satisfies:
=sumproduct((Date=A1)*(Hour=B3))
Press ENTER will do

To Sum another corresp named range: ReturnCol,
where the criteria satisfies:
=sumproduct((Date=A1)*(Hour=B3),ReturnCol)
Press ENTER will do

To return values from corresp named range: ReturnCol
where the criteria satisfies:
=index(ReturnCol,match(1,(Date=A1)*(Hour=B3),0))
Above must be array-entered, ie press CTRL+SHIFT+ENTER

Notes:
ReturnCol, Date, Hour are presumed identically sized named ranges
Lookup values in A1, B3 are presumed real dates & times
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jeff" wrote:
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