Complete the grid D$-$N$.$ Total Ticket Price should be based on the Base fare $($net of any adjustments$).$ Column N should compare the Total Ticket Price to the Corporate Fare. Make sure any $ amounts are formatted as such.

To give you practice using lookups, your grid columns D through K should include one hlookup, one index$/$ xmatch combo, one vlookup function with $[$range$\_$lookup$]$ set to TRUE, one vlookup function with $[$range$\_$lookup$]$ set to FALSE, three xlookup functions, and one function that is not a lookup function. You must decide which requested function use is most appropriate to each column by reviewing the data provided.

Any lookup functions must include a message other than #NA if the value is not found.

The final column should include Yes or No as the values.