Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lost on Vlookup, match, etc....
Can someone walk me through this please?
I a workbook that imports a years worth of data from filemaker to be analyzed and charted in excel. It contains several sheets, but I am concerned with worksheet 1 (daily data) and worksheet 2 (bodyweight). Daily data contains the raw data I pull in from Filemaker. It results in a table with a row for each day of the year. It has 12 columns, but in this instance, I am only interested in 2 of the colums Column F, (Date), and Column R (Bodyweight). There is only one entry per week for body weight. The bodyweight sheet has 3 columns (week #, date, and weight). The date is prefilled with the date of each Saturday in the current year. Sooooo, I want to match the date in the bodyweight sheet with the date in the Daily Data Sheet (f2), and grab the corresponding bodyweight (r2), and display it in the weight week in the sheet 2. Sorry to be so long-winded, but this is driving me crazy. Any help appreciated. Al |
#2
|
|||
|
|||
just one question first, is the date in F2 the same date in sheet 2 or is it
a date within the week starting (ending) with the date in sheet2? Cheers JulieD wrote in message ups.com... Can someone walk me through this please? I a workbook that imports a years worth of data from filemaker to be analyzed and charted in excel. It contains several sheets, but I am concerned with worksheet 1 (daily data) and worksheet 2 (bodyweight). Daily data contains the raw data I pull in from Filemaker. It results in a table with a row for each day of the year. It has 12 columns, but in this instance, I am only interested in 2 of the colums Column F, (Date), and Column R (Bodyweight). There is only one entry per week for body weight. The bodyweight sheet has 3 columns (week #, date, and weight). The date is prefilled with the date of each Saturday in the current year. Sooooo, I want to match the date in the bodyweight sheet with the date in the Daily Data Sheet (f2), and grab the corresponding bodyweight (r2), and display it in the weight week in the sheet 2. Sorry to be so long-winded, but this is driving me crazy. Any help appreciated. Al |
#3
|
|||
|
|||
Assuming that there are 1000 rows in Daily Data, just Chan to suit, try this
=VLOOKUP(B2,'Daily Data'!$F$2:$R$1000,13,False) This formula goes in the bodyweight column row 2. -- HTH Bob Phillips wrote in message ups.com... Can someone walk me through this please? I a workbook that imports a years worth of data from filemaker to be analyzed and charted in excel. It contains several sheets, but I am concerned with worksheet 1 (daily data) and worksheet 2 (bodyweight). Daily data contains the raw data I pull in from Filemaker. It results in a table with a row for each day of the year. It has 12 columns, but in this instance, I am only interested in 2 of the colums Column F, (Date), and Column R (Bodyweight). There is only one entry per week for body weight. The bodyweight sheet has 3 columns (week #, date, and weight). The date is prefilled with the date of each Saturday in the current year. Sooooo, I want to match the date in the bodyweight sheet with the date in the Daily Data Sheet (f2), and grab the corresponding bodyweight (r2), and display it in the weight week in the sheet 2. Sorry to be so long-winded, but this is driving me crazy. Any help appreciated. Al |
#4
|
|||
|
|||
Thanks for the quick replies, Julie and Bob. Bob, your formula worked
perfectly. Thanks again, Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup finds a blank, but returns a zero - HELP! | Excel Discussion (Misc queries) | |||
Vlookup Syntax Error | New Users to Excel | |||
Need help with modifying VLookUp | Excel Discussion (Misc queries) | |||
Vlookup with VBA | Excel Discussion (Misc queries) | |||
Vlookup returns incorrect match | Excel Discussion (Misc queries) |