muchtoofine412
New Member
- Joined
- Jan 21, 2013
- Messages
- 2
I am having troubles with my =Vlookup function.. I am using for horse racing, as an entry form. I am wanting there to be a main entry page, and then from there, it sorts all of the horse/riders into their appropriate class.
I have about 10 different pages to my workbook. The first page, is the main page where I enter all of my information. From this page, I put down the Rider, Horse and what class they want to ride in. Each class has its own sheet. I used the Lookup function to transfer each rider/horse combination to the appropriate class page.
The problem I am having is that when I pull the people to the class sheets using the VLOOKUP function, it is also pulling the blank lines, which makes it hard to see when trying to record times at the races. Is there a conditional function that I can use to pull the correct information to the sheets and also not include the blank lines?
Another question I have:
Riders have the option of "rolling" their time from one class to the next. This means that they can run once and have that time count for multiple classes. Is there a way to get a function to transfer those times to the appropriate sheets?
Thank you so so so much in advance, I am stumped!
I have about 10 different pages to my workbook. The first page, is the main page where I enter all of my information. From this page, I put down the Rider, Horse and what class they want to ride in. Each class has its own sheet. I used the Lookup function to transfer each rider/horse combination to the appropriate class page.
The problem I am having is that when I pull the people to the class sheets using the VLOOKUP function, it is also pulling the blank lines, which makes it hard to see when trying to record times at the races. Is there a conditional function that I can use to pull the correct information to the sheets and also not include the blank lines?
Another question I have:
Riders have the option of "rolling" their time from one class to the next. This means that they can run once and have that time count for multiple classes. Is there a way to get a function to transfer those times to the appropriate sheets?
Thank you so so so much in advance, I am stumped!