Cop, c Saleem erpl Data calibri 11 A AT wrap Text Accounting Merge a center Summ

Question

Cop, c Saleem erpl Data calibri 11 A AT wrap Text Accounting Merge a center Summary Trip Costs Ground Transportation 1 Departure Date Round-trip shuttle 50 2 Return Date 8/23/2018 Rental car per Day 30 3 Rental car Total Highest 4 Lodging Basel Night 115 5 Total Base Lodi SIS 110% Shuttle or Total 12 Destination City City Type Car? Airfare Rental Lodging Meals Cost Boston 3 No 367 50.00 375 14 Miami Yes 392 150.00 330 5 Orlando 299 150.00 16 philadelphia 479 50.00 375 7 San Antonio 218 150.00 Washi No 469 50,00 420 oc places Cities E O Ask me anything

Explanation / Answer

=VLookUP(B13,A7:B10,2,FALSE)*B5 will give values accordingly

Syntax of Vlookup

=VLOOKUP (value, table, col_index, [range_lookup]),

here we are taking value in B13, Lookup column starts from A7 to B10 , width from A to B is 2, and Since it is exact match, FALSE is taken

Arguments in VLOOKUP

value - The value we need to look in the first column of a table.

table - The table from which we retrieve a value.

col_index - The column in the table from where to retrieve a value.

range_lookup - [optional field] TRUE = if approximate match (default). FALSE = if exact match.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.