Hi Rich,
What is the "error message"? I see several error triangles, but no error messages, which can be revealed by clicking the red error triangle (and can be copied, then pasted here).
Reading your formula, I suspect these are flagging a Syntax error.
Have you looked in the Function Browser to read the syntax and description of the VLOOKUP function?
Your VLOOKUP formula, in N5 of the second table:
Syntax: VLOOKUP(search-for, columns-range, return-column, exact-match)
Your formula: VLOOKUP($A5, Flights::$A$1:$R$90, COLUMN, exact-match)
Revisions: Flights::$A:$R, 16,
Reasons:
search-for: This part is correct. You want VLOOKUP to get the value from column A of 'this row' on 'this table'
columns-range: The important part here is the columns. If your Flights data is consistent in its use of the labelled columns, even beyond row 90, then specifying only the columns (A to R) is cleaner, and works just as well as specifying the column and row for each limit.
column: Your formula does not indicate which column is to provide the data to be returned.
VLOOKUP always searched in the leftmost column of the specified columns of the lookup table—in your case, column A of Flights.
The column argument tells VLOOKUP which column contains the data to be returned, specifying that column by number, counting from the left, with the search column (A) set to 1. P is the sixteenth letter of the English alphabet, so this argument has to be set to 16.
close-match: VLOOKUP can be set to accept a close-match or to demand an exact-match to the search value. As you want to collect information for a specific flight, exact-match is the correct choice. If the flight sought is not listed (or contains a spelling error or typo), VLOOKUP will throw a "can't find" error.
Try the two changes suggested. The formula, as displayed should be entered in N5, and may be filled up or down from that row.
Regards,
Barry
Although this question applies to the same document as your earlier one, it is about a different topic/issue. Future questions, whose topics differ, should be posted as a new question.
Regards,
Barry