Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Done. I have attached a spreadsheet (My attempt.xlsx) following your instructions. I have one of my attempts at a solution in but it does not work at all.
f2=LOOKUP(E2,$B$2:$B$6,$A$2:$A$6)
Try this and copy towards down
=LOOKUP(E2,$B$2:$B$6,$A$2:$A$6)
if the result is in date format, change the cell format as general/number
Perfect. Seems like quite a straight forward formula! I may may have been over complicating it but there is just so much going on in Excel that I just get totally confused especially after trying to find solutions for several hours!
Thank you very much for your help and patience. This is caused me a real headache!
Much appreciated.
Margate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks