Return latest price based on exact match of Product and latest date

Hello @Patricia Stephenson, 

Thank you for reaching out to Microsoft Q&A Community. We're happy to support you with your concern. 

Based on your request, you want to get the latest price for "Apple" based on the latest date in your data. We highly suggest you should use the combination formula of INDEX and MATCH like below:  

=INDEX(Price column, MATCH(MAXIFS(Date column, Product column, "Apple"), Date column, 0)) 

You can try workaround and update us the news. Please feel free to reach out again if you need any further assistance and we will keep assisting you. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hi,

Try this formula in cell F2 (see the screenshot):

=LET(f, FILTER(A2:C10, A2:A10 = E2), c, CHOOSECOLS(f, 2), 1 / LOOKUP(2, 1 / FILTER(TAKE(f,, -1), c = TAKE(SORT(c,, -1), 1))))

Hope this helps.

Hello @Patricia Stephenson, 

It has been a while and we just follow up to see how you are doing. Do you have any more concerns about this issue? Any updates would be greatly appreciated.

Please don't hesitate to reach out again if you need any further assistance.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hello @Patricia Stephenson, 

We're reaching out again to follow up on your issue and to ensure that it has been resolved to your satisfaction. If you are still experiencing difficulties or have encountered any new challenges, kindly provide additional details regarding the specific steps where you are facing obstacles. We will remain at your disposal to offer any further assistance you may require.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Hi,

In cell F2, enter this formula

=GROUPBY(A2:A10,C2:C10,MIN,0,0,,B2:B10=MAX(B2:B10))

Hope this helps.