Vlookup/dlookup

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 10:03 PM GMT

Question

I am working on a work book for school and was told by my instructor that i could use the VLOOKUP and the DLOOKUP function to find out who worked on a particular project, how long they took on that project and add how much they should get payed for that project i was also told that it should look like this VLOOKUP(____,____[DLOOKUP(_____,______,______)],_____) can you pleas fill in the blanks for me hope that you understand my question and i would really appreciate the help thanks again

Answer

First of all what I would suggest is have a clear picture of the function which you are trying to use. What the function will do? and definitely if you know the usage of the function then i am sure you will pick the correct function on your own.

So I am giving you a small example file and some of the links to know more about what is Vlookup and how it works.

I have created a sample file for you to know how to use Vlookup. Click or Copy and paste the below link in web browser to download the Example file.

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

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

The File Name is: Vlookup Function With Diagram.xls

Have a look in the below links to have better understanding about how to use vlookup.

http://www.experiglot.com/2007/11/19/how-to-use-vlookup-in-excel-a-simple-tutori...

http://www.msofficeworld.net/2009/08/04/how-to-use-vlookup-vlookup-example/

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://www.techonthenet.com/excel/formulas/vlookup.php

http://www.mvps.org/dmcritchie/excel/vlookup.htm

I am sure that if you read all the above links and the example file then now you are having the answer in your hand whether Vlookup will do the trick or not.

Advertisement

©2017 eLuminary LLC. All rights reserved.