vlookup

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

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

Vlookup

resolvedResolved · Low Priority · Version 2007

Jason has attended:
Excel Advanced course

Vlookup

Basic V lookups ae fine but say if you want to look up different pages. Say you have an ID. And that ID represents different things in different formats, COuld you collate it in one vlookup.

Edited on Thu 15 Mar 2012, 11:00

RE: Vlookup

A vlookup will look up the table and column that you tell it to look up. It will not look up mufti tables. Is that what you are asking?

Wed 23 Nov 2011: Automatically marked as resolved.


 

Excel tip:

Colouring cells containing formulas

Cells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells.

Follow these steps:
1. Choose Edit > Go To menu, or press either F5 or Ctrl+G. Excel displays the Go To dialog box.
2. Click Special. Excel displays the Go To Special dialog box.
3. Select the Formulas radio button option.
4. Select OK.

At this point, every formula cell in the worksheet is selected, and those cells can be coloured formatted as desired.

View all Excel hints and tips


Server loaded in 0.1 secs.