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 » V-Lookups

V-Lookups

ResolvedVersion 2007

Wed 1 Jun 2011, 16:19 Delegate Luigi said...

Luigi has attended:
Excel Advanced course
Excel Advanced course

V-Lookups

I was a bit confused about how to get the number of columns in the table containing the relevant data.

Thu 2 Jun 2011, 13:14 Trainer Anthony said...

RE: V-Lookups

Hi Luigi, thanks for your query. When using a VLOOKUP the column index number is simply the number of the column in the table array you have selected. The right most column in a three column table will always be three, regardless of where that table is on the spreadsheet. That's all there is to it!

Hope this helps,

Anthony

Thu 9 Jun 2011: Automatically marked as resolved.

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

V-Lookups

V-Lookups

RE: V-Lookups

Excel articles

Excel tip:

Turn Function tooltips on and off