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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Vlookup

ResolvedVersion Standard

Fri 22 Feb 2008, 16:40 Delegate Deirdre said...

Deirdre has attended:
Excel Advanced course

Vlookup

Apart from numbering columns incrementally in a specific row or counting the columns, is there any way to determine the column number when using vlookup?

Sat 23 Feb 2008, 21:33 Trainer Cress said...

RE: vlookup

No - you will need to know the number of the column you want. You can get a list by highlighting the entire headings row and in a new tab right click in a cell. Choose Paste special and select transpose. This will give you a vertical list which might help you see what columns there are in a list format which you can then add numbers to.

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Vlookup

Vlookup

RE: vlookup

Excel articles

Excel tip:

Quickly create a list of numbers