Excel vLookup function - I think !
Can someone help me penetrate the Help on the vLookup function in Excel.
Here's what I want to do; an aviation example. I have an Excel list with a large number of records flight details, date, time, destination, etc. The destination on these records is shown as a code, eg EGLL. I want to put alongside this the name of the destination as well.
To me the easiest way to do this is to have a second worksheet in the workbook with a list of the destination codes and their names, and to link them. vLookup appears the tool to use but I cannot understand the syntax required. I guess it would be something like this :
Sheet 1 has the data and Column A contains the destination codes.
Sheet 2 has the table of codes (Col A) and names (Col B).
In Sheet 1 insert a blank Column B alongside.
B1 is something like =vLookup( go to Sheet 2, where column A = A1 in this sheet. Get column B and put it here).
Can someone translate this into Excelese for me please - or suggest a better way.
Thank you.