Cop, c Saleem erpl Data calibri 11 A AT wrap Text Accounting Merge a center Summ
ID: 3862632 • Letter: C
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 anythingExplanation / 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.