LinkBack URL
About LinkBacks
Try in H9:
With G9 contains end date of month.
=INDEX(C$8:C$22,MATCH(MIN(ABS($G9-$B$8:$B$22)),ABS($G9-$B$8:$B$22),0))
Confirmed with Ctrl-Shift-Enter
Copy down and across.
Try in H9:
With G9 contains end date of month.=INDEX(C$8:C$22,MATCH(MIN(ABS($G9-$B$8:$B$22)),ABS($G9-$B$8:$B$22),0))
Confirmed with Ctrl-Shift-Enter
Copy down and across.
Quang PT
when I tried to run the formual and adapt it to my actual spreadsheet i got an error message #N/A ?? I cant figure it out and have included teh entire worksheet and how it should look
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks