|Quoting TLG (Reply 2):|
Your formulae aren't Excel; are you sure you're not using a different spreadsheet? I'm familiar with Excel only, so I can't identify what it is exactly.
I edited the nested formula a bit to fit the Excel syntax, and it works:
=IF(E5="SAS","Scandinavian Airlines System",IF(E5="NAX","Norwegian Air Shuttle","Not Booked"))
The range (E5:500) isn't necessary; Row 5 should be E5, Row 6 should be E6, and so on.
Maybe I'm totally missing what you're trying to do here. If that's the case, then my response will be invalid.
|Quoting Dreadnought (Reply 1):|
Create a sheet2. Here you will have a list of all the world's airlines. Column A has the code, Column B has the full name.
Back to Sheet1, where you keep the log...
In column A, you enter the airline code, like SAS. In column B, you input a lookup formula. Try =VLOOKUP($A1,Sheet2!$A:$B,2,FALSE)
Then it just looks up the value in A2 in the list on Sheet 2, moves to the second column in the range and pulls that value.
|Quoting planejamie (Reply 4):|
Ignore Range Lookup
Military Aircraft Every type from fighters to helicopters from air forces around the globe
Classic Airliners Props and jets from the good old days
Flight Decks Views from inside the cockpit
Aircraft Cabins Passenger cabin shots showing seat arrangements as well as cargo aircraft interior
Cargo Aircraft Pictures of great freighter aircraft
Government Aircraft Aircraft flying government officials
Helicopters Our large helicopter section. Both military and civil versions
Blimps / Airships Everything from the Goodyear blimp to the Zeppelin
Night Photos Beautiful shots taken while the sun is below the horizon
Accidents Accident, incident and crash related photos
Air to Air Photos taken by airborne photographers of airborne aircraft
Special Paint Schemes Aircraft painted in beautiful and original liveries
Airport Overviews Airport overviews from the air or ground
Tails and Winglets Tail and Winglet closeups with beautiful airline logos