Reference cell in one TAB from another using two criteria

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 921

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I set the criteria in a sumif statement as a cell reference?	Duncan	Excel Worksheet Functions	3	July 27th 06 05:46 AM
SUMPRODUCT Criteria Via Cell Reference??	John V	Excel Worksheet Functions	8	April 12th 06 07:55 PM
How do you reference another cell in the criteria of a SUMIF funct	Hold the Onions	Excel Worksheet Functions	2	August 28th 05 12:06 AM
Could the "Criteria" in COUNTIF function be a cell reference?	JohnSheenWSN	Excel Worksheet Functions	2	June 16th 05 08:07 PM
Can I use a cell reference in the criteria for the sumif function.	Number Cruncher	Excel Worksheet Functions	2	November 4th 04 07:52 PM

All times are GMT +1. The time now is 12:06 AM.

Menu

About Us