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.
|