Hi. I have attached an excel sheet. With a tab called data that theoretically would have data for those months. In the other tab, I would like to create a lookup based on the date. Someone recommended this formula =OFFSET(Data!$A$1,ROW()-2,MATCH($B$1,Data!$2:$2,0)-1)
It works, but the only problem is that if I add rows in between in the first tab, the formula is no longer effective. Anyone have any suggestions. Many thankies and pankies.
Oops. Here is the attachment.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks