formulas that show other data only from Account Number ( need help plz )

guys i need a formula that show other data only from Account Number I already have the other data like (Account Name) & (Phone number)
& I already have Account Number on Excel & I want this formula to show the other data next to the Account Number this how it should be : file in Attachments

so I want this VBA code to work like this :
Account Number Account Name Phone number
311011 SFI 84745407
311013 MOG 84745401
311015 AUN 84745460
313545 SEF 84745455
311878 RA 84745462
313322 KAA 84745463
313329 TIR 84745448
311897 ASL 84745465
311810 MOUI 84745410
311877 OUL 84745999

so when ever I have Account Number the formula will show me Account Name Phone number ...

sorry for my poor english !! & thank you so much

Hi ZitNo,

You've posted in the VBA sub-forum but you're asking for a formula - do you want a routine or a formula??

Hi Zitno,

The action is in Sheet2 - just type the account number in Range("A1") Zitno.xlsm

Or with datavalidation (see orange cell).

The result is in the green cells.

Zitno.xlsm

Hi Zitno,

All the action is again in sheet2 - sheet1 is unnecessary

Just type the account number in Range("A1") and hit the enter button

You need to have set your system to accept macros:

File-Options-Trust Center-Trust Center Settings-Disable All Macros with notification(The second option button down)

And if that's not the problem then

Check out this thread

You're welcome!

Zitno.xlsm

Ok Zitno - Try this

You're welcome and thanks for the rep!

Hi Zitno,

Here is the event code in sheet2:

Please Login or Register  to view this content.

To change the column to C just change the red 1 to a 3

To be able to put the result anywhere on the sheet just delete that code line or put an apostrophe before it

You're welcome and thanks for the rep!

Hi Zitno,

You should mark this thread as solved - go to the top and click on thread tools