Index and match functions

[muskan27]

Q1. which airline (carrier code) has been booked at second largest price ?

I have used this formula- =INDEX('Airlines Data'!A1:K910,MATCH(LARGE('Airlines Data'!I2:I910,2),'Airlines Data'!I2:I910,0),2)

Please help me out if my understanding is correct or not


Q2. Find total revenue generated by the airline that was booked at minimum air fare .



I have attached a sample data below

[RaulSerg]

Q1 - Second largest: =INDEX($B$2:$B$13,MATCH(LARGE($I$2:$I$13,2),$I$2:$I$13,))
Q2 - I don't think your sample data includes enough information to answer this question?

[Limor_OP]

Hi,

Q2 - please try this:

H15 = =SUMIF($B$2:$B$13,INDEX($B$2:$B$13, MATCH(SMALL($I$2:$I$13,1),$I$2:$I$13,0)),$I$2:$I$13)

[muskan27]

Thank you Raul for such a quick response ...
1st part worked well ..

Thanks

[muskan27]

Thank you so much .. it worked