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

table vlookups

ResolvedVersion 2007

Robyn has attended:
Excel Advanced course

Table vlookups

is it possible to vlookup a specific column in an excel table? I can select the table name, but not the column. For example, count blank for BMI and BMI2

RE: table vlookups

Hi Robyn

Tables can be linked to vlookups can you send me an example of what your trying to do my e-mail is newson@stl-training.co.uk

Thanks

Newson

Sat 11 Sep 2010: Automatically marked as resolved.

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.