Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Insert Value
Hello,
I have two sheets in a workbook: MasterLog and Site Data. The MasterLog sheet gets updated pretty much every day. Each rowi o this sheet has a unique date. Periodically through the year, the Site Data sheet will get updated. Each row in the Site Data sheet has has a unique date. My boss wants me to append the values in the Site Data Log, to the assigned columns in the MasterLog, where hte dates match. What function can i use to do this? There are about 25 values i have to do this for. All values are contiguous. -- Carlee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match and Insert Value
VLOOKUP is a quick way to do this but you will have to change the column in
each category. EX. =VLOOKUP($L16,'[Site Data.xls]Sheet1'!$D$9:$G$17,4,FALSE) =VLOOKUP(*Cell date in Master Log*,*Table from where you're pulling data (date has to be in the far left of the range)*,*column in table that you want to pull data from*, FALSE) If you want more info on VLOOKUP there is fair help in MS Help (F1). Good luck! -- -SA "Carlee" wrote: Hello, I have two sheets in a workbook: MasterLog and Site Data. The MasterLog sheet gets updated pretty much every day. Each rowi o this sheet has a unique date. Periodically through the year, the Site Data sheet will get updated. Each row in the Site Data sheet has has a unique date. My boss wants me to append the values in the Site Data Log, to the assigned columns in the MasterLog, where hte dates match. What function can i use to do this? There are about 25 values i have to do this for. All values are contiguous. -- Carlee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and insert from one workbook to another | Excel Worksheet Functions | |||
Trying to use INDEX and MATCH to insert a value w/ multiple criter | Excel Worksheet Functions | |||
I want to match and insert info on 2 different sheets | New Users to Excel | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Index/Match to look up a value in one workbook and insert it into. | Excel Discussion (Misc queries) |