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 Richard Your Own Question

Richard, Computer Specialist
Category: Computer
Satisfied Customers: 33110
Experience:  Over 20 years of consulting to the IT industry
Type Your Computer Question Here...
Richard is online now
A new question is answered every 9 seconds

I have 2 sets of data. The first set contains 2 columns;

Customer Question

I have 2 sets of data. The first set contains 2 columns; Account Code and Contact Name, the other set contains 2 columns also; Account Code and Account Name. The Account Codes are unique to accounts but not to contacts.
I need to insert a third column in the first dataset to include the Account Name (from the second set) where the Account Name corresponds to the Account Code. I'm using Excel 2007.
Brendan Dunne
Submitted: 1 year ago.
Category: Computer
Expert:  Richard replied 1 year ago.

Hi there Brendan and welcome

From what you explained, I believe you need a vlookup?

This looks up a list of values, finds the link and returns a corresponding value.

So you would use something like

=vlookup(Cell with value to compare,where to search,which column number in the search to return)

Is this what you require?

Customer: replied 1 year ago.
Let me try it and I'll let you know.
Expert:  Richard replied 1 year ago.

Thank you