lookup tables

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Lookup tables

Lookup tables

resolvedResolved · High Priority · Version 2007

Wendy has attended:
Excel Advanced course

Lookup tables

Can look up tables be used when the actual data sourse is on another sheet?

RE: lookup tables

Hi Wendy

Thank you for your question and welcome to the forum.

Yes, you can use a VLOOKUP or HLOOKUP function to extract data from a table on another worksheet.

Amanda


 

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

View all Excel hints and tips


Server loaded in 0.1 secs.