I have been having trouble creating a formula that will do what I need. I know what I want it to read but I can't write it out to make any sense.
I need for E9 to look up the price of flights for the airline listed in cell C9 using the table in the worksheet FlightPrices. The formula should account for the amount of days Elizabeth wishes to stay in that country. If the price is unavailable, the cell should display a value of 0. It should be in a form that I'll be able to fill the formula down to cell E21.
Any insight would be greatly appreciated! Thanks!
Bookmarks