Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What Function to use?
Apologies - I think my oil filter is blocked and my brain is lacking all
lubrication! I cannot owrk out what function to use to select values from a table - can anyone please advise? In simple terms, I am trying to manipultae data as shown below: Input Output TABLE OF DATA Date Airport Sunrise FRA MAN 1 August 2005 MAN 04:25 03:54 04:25 2 August 2005 FRA 03:56 03:56 04:26 For each row, I want to input an airport (e.g. MAN, FRA) and obtain the correct sunrise time for that airport. There is a table of daily sunrise times for the airports - which is from where I want to be able to extract the data. Can anyone tell me how to do this - I have tried LOOKUP without any success. Thanks in advance Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |