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