vlookups

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Vlookups

resolvedResolved · Urgent Priority · Version 2003

Raymond has attended:
Excel Intermediate course
Excel Advanced course

Vlookups

How do I use Vlookups

RE: vlookups

Hello Raymond

Thank you for your question and welcome to the forum.

For a useful tutorial on the VLOOKUP function, please see the link below:
http://www.contextures.com/xlFunctions02.html

Kind regards
Amanda


 

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Server loaded in 0.07 secs.