I was messing around with a workbook for my fantasy football league and created a brain teaser.
On the QB sheet I want to return the week number when that particular QB has a bye from the Schedule sheet. For example, for Michael Vick and PHI, it should return 7. For Rodger and GB, it should return 8.
I think it's some nested lookup formula?
I know it's probably faster to do this manually with so few records, but I want to know what's up in-case I encounter this problem in a work related book.
I've attached the small workbook to make answering the question easier. Thanks!
Bookmarks