Results 1 to 2 of 2

VLookup, IF, Index help please.

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    2

    VLookup, IF, Index help please.

    Hey guys,

    I have a project I am working on for a class and it is killing me. I have tried some different ideas, but I have yet to figure out how to do it. I am going to do the best I can to explain it and hopefully you guys can help me out!

    So have a large data set that has all the info from a marathon race including times/ethnicity/age/and so on. It is rather fictional, because the teacher made it. Each row is one person and has all their information on it. My assignment is rather specific. It is to make a sheet that can take all this data and return only runners that were 35 years old, male, and (Three different options of "overweight, healthy, and underweight" and display the difference between their two finishing times.

    I know that it is going to be a conditional that matches the age, gender, and selection of health, but then I need it to subtract one cell in that row to the matching cell for the matching runner.

    Any help would be great. Thanks guys!!
    Last edited by aopsahl7; 10-11-2011 at 03:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1