Pulling a value from another sheet, based on date

C

Carlee

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top