excel training program - vlookups

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training program - Vlookups

excel training program - Vlookups

resolvedResolved · Low Priority · Version Standard

Lyndsey has attended:
Excel Advanced course

Vlookups

what is the biggest benefit of vlookups?

RE: vlookups

vlookup stands for vertical look up. It looks for a unique value in a named range and returns the related figure in the desired column of that range.

It's useful if you have to relate a lot of data to one unique datum. e.g. userID or part number.

it saves you typing in the description of a part number over and over again, if you are for instance typing out a job list fort people to make things.

Also, if you have something such as a form to fill in for students, you would have a list of their student ID, their first name and their last name. On a seperate sheet you could type in their student ID which they would tell you and their first and last names would show up instantly where you told them to, using vlookup

Any more questions, gimme a shout

RE: VLOOKUPS

Dear Paul

Thank you very much for answering that VLOOKUP query!!

You have answered the question very well!!

In addition to what you have said all I would like to say is that this can be very useful if you have all the products or services information on one sheet and the customers personal info on the other, You can then create a new sheet with an invoice which can use the VLOOKUP to extract the info for the the product/service and the customer info in the relevant section of the invoice!!

Thank you again!!

Kindest Regards

Rajeev Rawat


 

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips


Server loaded in 0.1 secs.