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.
how do I attach the file?
You should see a paperclip icon in your reply box - clicking it starts a two-step process to attach a file.
it says it is for inserting an image.
It does say that, but it actually allows you to attach all sorts of files (up to 5MB in size) as well as images....
Did you get it?
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?
disregard the date thing. I figured it out myself.