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.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Jess M. Your Own Question
Jess M.
Jess M., Computer Support Specialist
Category: Programming
Satisfied Customers: 11067
Experience:  Computer Hardware & Software Specialist - 10yrs Exp, Web Designer & Developer
49766785
Type Your Programming Question Here...
Jess M. is online now

Can you put me through to someone who is a expert on excel,

Customer Question

Hello. can you put me through to someone who is a expert on excel
JA: What application are you using?
Customer: Excel not sure on latest version
JA: Have you installed any updates recently?
Customer: No just need to know about a lookup
JA: Anything else you want the Microsoft Office Expert to know before I connect you?
Customer: no thanks
Submitted: 14 days ago.
Category: Programming
Expert:  Jess M. replied 14 days ago.

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.

I am very sorry about your issues.

Are you using a Windows computer or a Mac?

What exactly do you want to accomplish on your Excel?

Thank you and please let me know so that I can assist you further.

Best regards,

Jess

Customer: replied 14 days ago.
Posted by JustAnswer at customer's request) Hello. I would like to request the following Expert Service(s) from you: Secure Remote Assistance.
Customer: replied 14 days ago.
Let me know if you need more information, or send me the service offer(s) so we can proceed.
Expert:  Jess M. replied 14 days ago.

Are you using a Windows computer or a Mac?

What exactly do you want to accomplish on your Excel?

Customer: replied 14 days ago.
Windows .... I am trying to do Vlookup
Customer: replied 14 days ago.
But struggling to make it work
Expert:  Jess M. replied 14 days ago.

Can you send me a sample Excel file with dummy data so that I can make the vlookup formula for you?

Customer: replied 14 days ago.
on one tab I want to pull the information once its entered on a tab and bring into another tab in the excel sheet
Expert:  Jess M. replied 14 days ago.

That is fine. Vlookup should still work even if the data are stored in different sheets.

Customer: replied 14 days ago.
Just sent it you please let me know once you have it open so can talk it through
Expert:  Jess M. replied 14 days ago.

I got the file.

Customer: replied 14 days ago.
Thanks
Customer: replied 14 days ago.
when a trailer information gets entered in column I on the control sheet it needs to come through on yard plan (tab) to the matching bay number
Expert:  Jess M. replied 14 days ago.

Can you tell me what sheet or cell you are working on?

Expert:  Jess M. replied 14 days ago.

The Yard Plan is a protected sheet.

Customer: replied 14 days ago.
just click unprotect
Expert:  Jess M. replied 14 days ago.

What is the unique data that needs to be matched?

Customer: replied 14 days ago.
when a trailer information gets entered in column I on the control sheet it needs to come through on yard plan (tab) to the matching bay number
Expert:  Jess M. replied 14 days ago.

So the matching information on the 2 sheets is the BAY Number?

Customer: replied 14 days ago.
that is correct
Expert:  Jess M. replied 14 days ago.

Thank you for patiently waiting. The formula needs to be entered in the Yard Plan Sheet. For cell BB15, the vlookup formula is:

=VLOOKUP(BB14,'Control sheet'!$A$4:$I$16,9,FALSE)

I just used the table 'Control sheet'!$A$4:$I$16 for this example, that is until row 15 only, and until column I. You can include more rows if you want. Also, the array is locked so that you can copy it easily.

Attached is the completed file.

Thank you for using our service. If you can rate my answer positively if you have time, it will surely boost my overall service score. Tips are optional but is highly appreciated.

Best regards,

Jess

Customer: replied 14 days ago.
Thanks if i need anything extra your here for more ?
Expert:  Jess M. replied 14 days ago.

Please post it as another question and you can request me to answer it. This question could be marked as solved already.

Thank you.

Best regards,

Jess