I need the vlookup function for this part. Thank you. race Pr Tt Use in Formula-
ID: 2554970 • Letter: I
Question
I need the vlookup function for this part. Thank you.
race Pr Tt Use in Formula- Trace Dependents Insert AutoSum Recently Financial Logical Text Date & Lookup & Math&More; Name Function Time Reference Trig. Functions Manager Create from SelectionRemove Arrows Error Checking Evaluate Form Used Function Library Defined Names Formula Auditing F13 1 Departure Date 2 Return Date 8/18/2018 8/23/2018 Ground Transportation Round-trip Shuttle $ Rental Car per Day$ Rental Car Total$ Summary Trip Costs Average Lowest Highest 50 4 Lodging Base/Night 5 Total Base Lodging city 115 S 150 575 COL 95% 110% 125% 2 10 Rental Shuttle or 12 Destination City City Type Car? Total Airfare Rental Lodging Meals Cost 13 Boston 14 Miami 15 Orlando 16 Philadelphia 17 San Antonio 18 Washington DC 19 20 NoS 367 50.00 392 $ 150.00 299 $ 150.00 479 $ 50.00 218 $ 150.00 469 $ 50.00 $ 375 2 Yes 285 No Yes No 285 420Explanation / Answer
Use this formula for your requirement :
= ROUND ( B$5 * VLOOKUP(C13,A$7:B$10,2,FALSE) , 0 )
Here we have to use comibination of 3 formulas to get your answer.
Those are
1 - ROUND Formula -
To round the answer to nearest dollars
use this assumption, Round ( a * b, 0 ), to get rounded answer nearest to dollar.
2 - Multiplication Formula
To multiply B5 with Vlookup result
Instead of B5, we have to B$5 to avoid reference changing while copy paste formula.
3 - VLOOKUP Formula -
to pick the % value based on given city code ( City Type )
analysing VLOOKUP(C13,A$7:B$10,2,FALSE)
C13 - which ( City Type ) code to be searched in particular range or table
A$7:B$10 - range or tabel as per our requirement to check ( City & COL )
instead of A7:B10, we have to A$7:B$10 to avoid reference changing while paste formula.
2 - Which column value to be taken for calculation ( COL )
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.