Finding the down payment

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:37 PM GMT

Question

we are working on a spreadsheet that has the selling price, loan term, interest rates, % required for a down payment. Now we have to sue vlookup in order to find the down payment, amount to be financed, and the monthly payment. I understand how to find all of them the old fashion way as they say, but I don't understnad how to do the so called: =vlookup what am I suppose to be using in all these so called formulas? I am confused.

Answer

I have created sample files for you, Click or Copy and paste the below link in web browser to download the Example file.

http://www.sendspace.com/file/kwez47

Scroll the mouse button to the bottom of the website and click Download

The File Name is: Vlookup Detailed Clarification.zip

Have a look in the below link to know more about Vlookup and how to use it. http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Advertisement

©2020 eLuminary LLC. All rights reserved.