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 from Column A.
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!

Formula.xlsx