Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 155
Default Pulling a value from another sheet, based on date

Hi there,

I have two Sheets: A & B

Each date a row of data is entered into Sheet A, including: Reading Date
and Recovery

Every week or so, a row of data is entered into Sheet B, including: PLS
FLOW and Reading Date.

PLS FLOW, on Sheet B is pulled from the Recovery column in Sheet A, using a
reference.

Problem:
I need to make sure that the PLS FLOW value referenced on Sheet B, from
SHeet A, is pulled from the right row, based on Reading Date.

Example,
Reading Date on Sheet A is June 10, containing a value in the Recovery column.
Reading Date on Sheet B is June 10, containing the PLS FLOW column, which is
the Recovery column on Sheet A, for the specific date

Issue:
Sheet B rows are entered two weeks after the values for Sheet A are entered.

Can anyone help me with this?

Basically i am trying to make sure that the right value is referenced, for
hte right date.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Pulling Information into a sheet via date Schwimms Excel Discussion (Misc queries) 2 May 30th 07 06:47 PM
Pulling info from other spreadsheets based on a set of criteria... watchtower Excel Worksheet Functions 1 February 3rd 07 02:32 AM
Pulling out data based on font colour terryc Excel Discussion (Misc queries) 1 July 3rd 06 09:51 PM
How do I generate a new sheet based on date/week/month? Jay Excel Worksheet Functions 1 January 10th 06 08:50 AM
Newbie question Pulling data from one sheet to another based on Tony Canevaro New Users to Excel 16 October 25th 05 02:10 PM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"