Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling Information into a sheet via date | Excel Discussion (Misc queries) | |||
Pulling info from other spreadsheets based on a set of criteria... | Excel Worksheet Functions | |||
Pulling out data based on font colour | Excel Discussion (Misc queries) | |||
How do I generate a new sheet based on date/week/month? | Excel Worksheet Functions | |||
Newbie question Pulling data from one sheet to another based on | New Users to Excel |