Blade Air Mobility and Joby Aviation: *The Deal: Blade Air Mobility is selling its helicopter passenger rideshare business to Joby Aviation for $125 million. This deal is causing Blade's stock to surge up to 30% and Joby's stock to rise over 5%. *What's included in the deal: Joby Aviation is acquiring Blade's helicopter rideshare service, which offers transportation from various New York City landing spots to nearby areas like the Hamptons or airports such as Newark Liberty International. *What's not included: Blade's medical transport business will be spun out into a new public company called Strata Critical Medical, and Joby won't be taking that over. *Some stats about Blade: - *Passengers transported: Over 50,000 passengers in 2024 - *Terminals: 12 different terminals operating from Blade Air Mobility operates in two main segments²: - *Passenger: Offers helicopter and seaplane flights in the US and Europe - *Medical: Transports human organs for transplant...
Look up function
Look up faction provides corresponding value in row or column to look up value . To put simply it gives us corresponding value of look up value given in another column . In this case , I want rating of Aviva company which mean my lookup value is Aviva and I want corresponding value for Aviva that is "BBB" given in Rating column of table .
Formula
Lookup=(lookup_value,Lookup_vector,result_vector)
lookup value mean value for which we looking for corresponding value, in this case "Aviva"
Lookup array mean column/row where look up value is
result vector mean column/row from where to find corresponding value
so my formula come as =LOOKUP(K12,Table3[Agent Name],Table3[Rating])
2nd type in lookup
Formula
=lookup(lookup_value,array)
lookup value mean value for which we looking for corresponding value, in this case "Aviva"
array mean selection area from which corresponding value in last column/row is taken.
Note look up value should be always in first column/row and corresponding value in last column/row .
In this case my look up value is Aviva and corresponding value we want is in F column so we should select array from Agent name column to Rating column .
=LOOKUP(K15,Table3[[Agent Name]:[Rating]])
Comments
Post a Comment