I have a sheet (Calendar) where users will pick a date in cell A1. This cell is setup with a data validation that pulls from sheet (Info) in Column A.
I would like it to automatically populate A2 on the Calendar sheet with whatever value is in the next row from the value they selected on the Info tab.
Example:
Sheet: Calendar
Cell: A1
Value: 11/17/2014
Sheet Info
Cell: A22
Value: 11/17/14
Cell: A23
Value: 11/24/14
Sheet Calendar, Cell A2 should then return 11/24/14
Try:
Formula:
=INDEX(Info!A:A,MATCH(A1,Info!A:A,0)+1)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This is perfect. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks