function vlookup?

Description: 2 worksheets.
Worksheet 1 (titled "Workouts") This is a list with two columns. Column A is the code for a specific workout (i.e. BRW3). Column B is the description and details of said workout.

Worksheet 2 (titled Schedule). This sheet contains 4 columns. Column A is the days of the week. Column B is titled "Swim". Column C titled "Bike" Column D titled "Run". There are ten rows under each column for each day of the week.

Question:
I want to create a formula that will pull the specific workout from worksheet 1 (workouts) based on me using the workout codes from worksheet 1 to create my weekly workout schedule.

I have fiddled with the "if" function as well as the "vlookup" function and i'm struggling. Any help would be greatly appreciated. I would also be able to upload or email the file if any willing to help.

Thanks. Ryan

I am a hands on person, so you would first have to zip the files. then attach them to your post with the paperclip so I can see them.

It would be nice to have one of the sheets contain the results of what you want, even not in a formula version, or a few cells with the results just typed in to compare to make sure I have the correct data.

After that I can attempt to help you achieve your results. I am not a pro but I can move around pretty good. Also there are some other awesome people on here I am sure would be willing to help.

bpaw

Attached is the file...the 'demo' worksheet is what i put together as a model for what i want to do. The 'workout' sheet is the list of workouts with the codes used, and the 'schedule' sheet is the sheet that I'm trying to use. I typed in a few manually....

Thanks a ton. Hope this helps you help me!

Ok, here is the deal. I have found a way to possibly make it work, but what I am confused about is the workouts.

Can you tell me which ones would appear in which columns.
Basically, would all the bw's go under bike, the cf's go under swim... etc?

This is actually a harder formula, simply because I don't think that all workouts go under each column, and the minute you type into the field the formula would then disappear. advanced users may use a different method that what I am doing, but mine would work as well if I had the above information.

if you post the info I asked for then I should have it done in a matter of moments.

bpaw

ok, I am sure with more research and knowledge there maybe a simpler or better way to to what you are asking, however, the problem that I ran into would be the fact you are asking for multiple data to be read in one cell and spread across three cells.

You are also lacking a way for data to be entered. To my experience the moment you type in a cell the entered formula would disappear. I don't know if there is a way round this.

While I am sure this can be done, and some of the more experienced people would know how to accomplish this, I do not as I am only an advanced user (hopefully advanced category) not an expert. I do not currently have enough knowledge for this function.

I did however give an example of what I would do until I could gain the knowledge to get it done in one formula.

I also did not know which data should go in which field as I am not familiar with the types of workouts you have listed.

So currently any data you type in the A column from cells a1-a19 would appear in the swim column, Data typed into the B column from a20-a25 would appear in the bike column, and Data typed in the C column from a26-a45 would list in the run column.

With a little more information, I might be able to do something different. For example, finding out if you are in fact going to be listing multiple data into one field (ex. brw3a, cfr2 in to one cell and have the output listed in two separate cells.) and also where you are going to be listing the data. Did you plan on listing it directly into the cell then have the cell convert it to the description?

let me know....

bpaw

b data appears in the swim column
c data appears in the bike column
d data appears in the run column

b data is the cells referenced on workout sheet cells a1-a19
c data is the cells referenced on workout sheet cells a1-a25
d data is the cells referenced on workout sheet cells a26-a45

sorry, it was early this morning when I typed up the information.

bpaw

Oh man...you are awesome...
I guess it would help if i explained the workouts a little better. I have alot to add to the list but the workouts are coded as follows:
-beginning with "c" are cycling workouts
-beginning with "r" are run workouts
-beginning with "s" are swim workouts
-beginning with "b" are Brick workouts and are bike and run combined. (which could go under the cycling column)

the setup you have looks pretty good, i just don't understand how the lookup works or how it's limited to certain cell ranges. Can you have them all reference the whole list?! or when i get the list complete should the formula's be adjusted?!

I hope that helps a bit.

Thanks a ton for the help thus far!!!!
Ryan