Please see the attached workbook. I cannot figure out how to pull the most recent owner of the bond into Col B on Sheet 2. I want BondIDNo #1 to pull "0" as the customer number since that customer has the most recent issue date.
Please see the attached workbook. I cannot figure out how to pull the most recent owner of the bond into Col B on Sheet 2. I want BondIDNo #1 to pull "0" as the customer number since that customer has the most recent issue date.
Last edited by narrowgate88; 09-29-2016 at 09:41 AM.
If you custom sort Sheet1 by BondIDNo and then IssueDate (Newest to Oldest), you can then use in Sheet2 B2 copied down...
=IFERROR(INDEX(Sheet1!C:C,MATCH(A2,Sheet1!B:B,0)),"")
HTH
Regards, Jeff
You can try this array formula on B2 and copy down :
Press Ctrl+Shift+Enter to confirm array formula.Please Login or Register to view this content.
Or use VLOOKUP
Enter formula on Sheet2 in cell B2 and copy down
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you everyone. jefferybrown's response got me what I was looking for.
You are welcome and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks