LinkBack URL
About LinkBacks
Hi i have a very simplistic vlookup that returns a date all i want to do is return the date located in the cell above it but for some reason i just cant work out how to do it. Should i be using something instead of a vlookup?
Hi i have a very simplistic vlookup that returns a date all i want to do is return the date located in the cell above it but for some reason i just cant work out how to do it. Should i be using something instead of a vlookup?
try using indx/match to find what you want, and in the 1st match, use -1 at the end
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this structure:
Formula:
Please Login or Register to view this content.
Does that help?
Good Point, got it working thanks.
Please Login or Register to view this content.
If you will be copying this down (or across) anywhere, you will need to absolute ($) some of those references
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks