Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Vlookup

Resolved · Urgent Priority · Version 2007

Reply Mon 12 Dec 2011, 16:37Delegate Amaka said...

Amaka has attended:
Excel Advanced course

Vlookup

Please can you explain to me how to creat a Vlookup using a set of data.

For upcoming training course dates see: Pricing & availability

Reply Tue 13 Dec 2011, 16:49 Edited on Thu 15 Mar 2012, 10:56Trainer Paul said...

RE: Vlookup

To learn how to run a vlookup from scratch you are best to go to a website and view a tutorial... try this one http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Alternativly type vlookup into youtube.com and watch the video on how to create, it's a lot easier than try to understand it in a text format that I would give you.

Excel articles

· Creating Tables Automatically In Excel 2010
· How Sharing Your Excel Data Can Help Your Business Flourish
· A Blinking Good Excel Tip
· Interesting Things About Charts In Excel 2003
· Basic Excel Training

Please browse our web site to find out more about
exce+training and other Microsoft training courses.

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips