Need help with showing values in Excel

welcome to the forum Hoogoo,

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.

Thanks for the quick reply,

Excel help.png

I have remade the situation in paint.

As i said, the value in Sheet!3 E2 needs to copy the value at Sheet1! H2, only if the value at Sheet1! E2 equals the value at Sheet3! $H$2, and so on.

EDIT:
Just noticed the values in the picture don't match. They should be the same at Sheet1! E2 and Sheet3! H2

Please attach a sample excel file instead of Image with some more examples

Try pasting the following formula into cell E4 on Sheet3 and copying down:

Formula:

Please Login or Register  to view this content.

I am guessing that you have Excel version 2010 or later, if not a different solution will be needed due to the use of the AGGREGATE function.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.
P.S. Please update your profile to show the version of Excel that you are using. This will help contributors give you answers should you have further questions.