Table vlookups

Resolved · Low Priority · Version 2007

Mon 23 Aug 2010, 17:04 Delegate Robyn said...

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

Tue 24 Aug 2010, 13:51 Trainer Newson said...

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.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Recently used file list

Under the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files.

You can disable the file list feature of Excel. This is done by

1. Choose Tools > Options menu. You will see the Options dialog box.
2. Ensure the General tab is selected.
3. Make sure the Recently Used File List check box is cleared.
4. Click on OK.

View all Excel hints and tips