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.
I have created sample files for you, Click or Copy and paste the below link in web browser to download the Example file.
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