Forum Discussion
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with ...
Thank you, I will try Xlookup as shown above! The event is entered in Spreadsheet B next to the Rider number, it would be in column A row 2. I do have to manually enter the rider number, event name and class into Spreadsheet B. Thankfully I can copy the event name and class, I just have to manually enter each rider number.
It sounds like you are creating a sheet for each rider.
You create 1 sheet and change the rider on that sheet (you could use Data Validation to create a drop down list).
You could also use pivot table or similar as I mentioned and then just select the rider.
If you have a sample workbook and more about what you need, have, want I'm sure we could get you to the finish line.