Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is a Match ?
Good Evening All,
I have many sheets in my workbook. Two of them are data collection sheets. Sheet A and Sheet B. Both sheets have a date column in them In sheet A, a new row is added every day. The rows are made unique by the date. Sheet B, is added once a month or so. Question: the column named 'PLS Flow' is listed in both sheet A and sheet B. Sheet A gets a new PLS Flow reading each day. I need to pull the value of the PLS Flow column, into Sheet B, to use in a calculation. Here is what i need. I need to be able to pull the PLS Flow value from Sheet A, into Sheet B, for the required date. I think i need to use an IsMatch function, but not sure how to apply it here. Can anyone help? I want to populate the 'PLS Flow' column of sheet B, by searching in Sheet A, for PLS Flow, for the date of th -- Carlee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is a Match ?
See if this helps:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Carlee" wrote in message ... Good Evening All, I have many sheets in my workbook. Two of them are data collection sheets. Sheet A and Sheet B. Both sheets have a date column in them In sheet A, a new row is added every day. The rows are made unique by the date. Sheet B, is added once a month or so. Question: the column named 'PLS Flow' is listed in both sheet A and sheet B. Sheet A gets a new PLS Flow reading each day. I need to pull the value of the PLS Flow column, into Sheet B, to use in a calculation. Here is what i need. I need to be able to pull the PLS Flow value from Sheet A, into Sheet B, for the required date. I think i need to use an IsMatch function, but not sure how to apply it here. Can anyone help? I want to populate the 'PLS Flow' column of sheet B, by searching in Sheet A, for PLS Flow, for the date of th -- Carlee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |