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

Pete
Pete, Computer Engineer
Category: Mac
Satisfied Customers: 10244
Experience:  HNC Computing, CISCO certified technician.
30970729
Type Your Mac Question Here...
Pete is online now
A new question is answered every 9 seconds

I have spreadsheet in excel 2011 for mac with a table of 500

Resolved Question:

I have spreadsheet in excel 2011 for mac with a table of 500 airline flights, many of which are duplicates. I will call this table A. I have copied the table and pasted it in columns to the right. After doing so, I ran the function to remove duplicates. I will call this table B. Now that table B has no duplicates, I want to enter the baggage claim number for each flight in table B.

Here is my problem. I want each flight entry in table A to query table B until it finds the matching flight number, then copy the baggage claim for that flight into a cell adjacent to the flight number in table A

example:

table A baggage claim table B baggage claim
AA 1234 AA 1234 B1
AA 1234 DL 1342 E9
AA 1234 AA 2309 B8
DL 1342 UA 1652 C2
AA 2309 US 1901 C17
UA 1652
US 1901
US 1901

I want a formula/function that will look at table A, find AA 1234, then query table B, find AA 1234, then copy baggage claim B1 into the blank cell under column "baggage claim" in table A adjacent to every AA 1234 entry, and so on.....

Can anyone help me?
Submitted: 10 months ago.
Category: Mac
Expert:  Pete replied 10 months ago.

Hello,
I am Pete, and I'll be happy to assist with your question today.

 

This problem can be solved using a VLookup formula.

 

If you are not sure how to do it, or need further assistance, please attach the spreadsheet or a similar sample spreadsheet so I can insert the formula for you.

 

Customer: replied 10 months ago.

how do I attach the file?

Expert:  Pete replied 10 months ago.

Hi John,

You should see a paperclip icon in your reply box - clicking it starts a two-step process to attach a file.

 

Customer: replied 10 months ago.

it says it is for inserting an image.

Expert:  Pete replied 10 months ago.

It does say that, but it actually allows you to attach all sorts of files (up to 5MB in size) as well as images....

Customer: replied 10 months ago.
Customer: replied 10 months ago.
Expert:  Pete replied 10 months ago.
Yes, I got it and I have a solution for you now which I am trying to attach...
Expert:  Pete replied 10 months ago.
Hi John,

I have added the VLookup formula for you.
As the airline and flight were in separate columns, I first combined them in new columns (D & K) and then hid those new columns to make the data more presentable.

I am unable to attach the file here for some reason, so I have uploaded it to Wikisend and you can download it using the following link:

Pete, Computer Engineer
Category: Mac
Satisfied Customers: 10244
Experience: HNC Computing, CISCO certified technician.
Pete and 5 other Mac Specialists are ready to help you
Customer: replied 10 months ago.

I forgot to tell you it has to factor in the arriving date. It appears vlookup does not. Look at AA 3009. It arrives on both the 14th and 15th, however; the baggage claim is different on the 15th than it is on the 14th. Your formula added the baggage claim for that flight on the 14th to the flight on BOTH the 14th and 15th. Can you fix it so that it looks at the arrival date, then the flight number?

Customer: replied 10 months ago.

disregard the date thing. I figured it out myself.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified