Need index/match or vlookup to return results (check against 2x crtieria)

Hi guys,

I have a spreadsheet attached with 2 tabs. On tab 2, you can see a formula to return the cheapest travel agent and corresponding price. I want to add a formula in column D, to return the 'note' (column E on first tab) which corresponds with the cheapest travel agent and price

Can anyone please help?

thanks,

R.

Not easy to help when you give only one example of what you want and it isn't working:

Excel 2016 (Windows) 32 bit

	A	B	C	D
1	Agent	Price (pp)	Total price	Notes
2	#N/A	#N/A	#N/A	Sunny Lisbon Guesthouse/residence (3*), Double room with shared bathroom. Rollaway bed requestable €12 due at hotel (unsure if it is pn?)

Sheet: Lisbon cheapest