Using of Function

Resolved · Medium Priority · Version 2007

Thu 3 Sep 2009, 15:55 Delegate Megha said...

Megha has attended:
Excel Intermediate course

Using of Function

How to use VLOOKUP Function

Fri 4 Sep 2009, 16:27 Trainer Amanda said...

RE: Using of Function

Hello Megha

Thank you for your question and welcome to the forum.

Please find below a link to download the handbook for our Excel Advanced course - this contains an explanation of how to use the VLOOKUP function. The reference material is for the Excel 2003 course, however in entering the VLOOKUP function into Excel 2007 you would follow exactly the same process.

https://www.stl-training.co.uk/download/trainer/courseware/excel_2003_advanced.zip

Kind regards
Amanda

Fri 11 Sep 2009: Automatically marked as resolved.

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

Using of Function

Using of Function

RE: Using of Function

Excel articles

Excel tip:

Fill formulae across a sheet