LinkBack URL
About LinkBacks
Refer to attached spreadsheet. In B1 is the day of the month and I want to match it to the number in the grid and return a Y or N in the Occupied column if a code is in that row. So on the attached spreadsheet, all would be Y except for Row 15.
Refer to attached spreadsheet. In B1 is the day of the month and I want to match it to the number in the grid and return a Y or N in the Occupied column if a code is in that row. So on the attached spreadsheet, all would be Y except for Row 15.
welcome to the forum, AndreaJean. try in AF5:
=IF(INDEX(A5:AE5,MATCH($B$1,$A$4:$AE$4,0))<>"","Y","N")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Another variation........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Excellent! That worked perfectly. Thank you so very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks