View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlee Carlee is offline
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.