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...
Match Function
Match function provides us with position no of lookup value in row or column as per given reference.
Formula: match=(lookup_value,Lookup _array,[match_type])
Lookup value is value of reference of cell value we want excel to look for in table/lookup array
lookup array is a area where we instructs excel to find look up value
match type is either 1 which find less than ,0 which is exact match ,-1 which is greater than lookup value
now we want position no of Aviva company given in column D
as you see in above screenshot look up value is Aviva which is on K5
lookup array is table3 which is A1:H16
0 exact match
Note
Match function is used in many formula to give reference.
Insightful
ReplyDelete