How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Jess M. Your Own Question
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6785
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

Hi i have a employee telephone list of +- 250 exts on a spread

This answer was rated:

Hi i have a employee telephone list of +- 250 ext's on a spread sheet all employees data is is displayed in 6 different columns starting with the 1st name, last name & so on. I need to insert a formula that when i type the 1st name of the employee that all the data of the employee is displayed at the top of the spreadsheet next to the 1st name entered, can you assit
Hi, welcome and thank you for your question. My name is XXXXX XXXXX I am glad to assist you today.

Is it possible that you can send to me a few sample data of the spreadsheet that you are working on? It will be easier for me to understand your problem with the sample Excel file where I can work on and then describe to you the process and the formula needed.

If this is possible, upload the file to http://wikisend.com. No need to register there, just upload it and wait for the page to display the 6-digit File ID or download link. Then post the 6-digit File ID here when you reply so that I can get your sample file. More information on this link:

http://www.technicalforum.org/windows/how-easily-share-files-using-wikisend


Please let me know so that I can help you further.

Best regards,
Jess
Eugene,

I have created the vlookup formula for you. Please download the modified file from this link:
http://wikisend.com/download/744410/TELEPHONE_WORKSHEET_rev1_jess.xls

The goal of the vlookup formula is to lookup the content of C2 (the name) in the table C8:H26 and then return the values of columns 2, 3, 4, 5, and 6 respectively.

Please remember to rate my service positively (3-5 stars/faces) once you have all the information you need. Tips are always highly appreciated! Cool

If you have any other questions, please ask me or reply to me – I’ll be happy to respond.

Thank you!

Best regards,
Jess
Jess M. and 5 other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions