Return cheapest flights (by supplier, price and sort)

Hi all,

Yes this is my weird, nerdy excel desires.. to track my best options for flight prices for an upcoming holiday.....

I have setup a spreadsheet here:

https://docs.google.com/spreadsheets...it?usp=sharing

However, on sheet 2, I want the list of suppliers to be returned with prices (and preferably I would have this sorted by the 'lowest') price. Hope this makes sense? Assuming it may need an index and match function but I`m not very well versed with this? Still learning it.

Thank you in advance.

Hi John,

Thank you for your reply. I provided a link here:

ttps://docs.google.com/spreadsheets/...it?usp=sharing

I`m unable to locate the option (like I saw yesterday) to attach the spreadsheet. Sorry! I even looked in edit post?

@ rayted,

Try this.

To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

@FlameRetired, please find attached - thanks for your help with the instructions

rayted, I get a warning that Excel found some problems with the content of your upload. I didn't open it.

strange.. try again? I just re-saved it as a new file... seems like there were some errors in the file. It was previously a google docs file which I downloaded... so maybe that's a problem

ARRAY formula in A2, then drag across upto Q5.
Merging of cells not allowed, because ARRAY frmulaswill not accepted in merged cells.

Please Login or Register  to view this content.

Hi there

Thank you for this - this is helpful however:

1) I get no return for using the last 3 travel agents i.e. if i change the value to £1 for either
Cheapflights
Travelup
Travelhub

It returns N/A

All of the other travel agents returns the value as it should?

Thank you!

Thanks John, all fixed! Thank you so much both