Please check the attached file. I need a corresponding cell based on the condition of another cell.
Please check the attached file. I need a corresponding cell based on the condition of another cell.
Try this...
=INDEX(C8:C31,MATCH(D36,D8:D31,0))
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
or this
=LOOKUP(D36,D8:D31,C8:C31)
Remember format D39 as DATE as well.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Happy to help and thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks