Find and Display the First Amount Associated with an Account Number

[infame]

Hello everyone,


I need help with a task. My data is organized as follows:

• Column B contains the account numbers.
• Column A contains the associated amounts.

What I need to do is:

1. Search for a specific account number in Column B.
2. When found, retrieve the first corresponding amount from Column A.
3. Display that amount in Column C, right next to the found account number.

I want to do this individually, meaning one account at a time. What would be the best way to achieve this?


I really appreciate your help!

 

[p45cal]

cross posted without links:

Find and Display the First Amount Associated with an Account Number

Hello everyone, I need help with a task. My data is organized as follows: Column B contains the account numbers. Column A contains the associated amounts. What I need to do is: Search for a specific account number in Column B. When found, retrieve the first corresponding amount...

www.excelforum.com

@infame, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of https://excelguru.ca/a-message-to-forum-cross-posters/