excel training courses london - look up formula designated
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses london - Look Up formula for designated details on another sheet

excel training courses london - Look Up formula for designated details on another sheet

The UK's most regular instructor-led training courses.
Training information: excel training courses london, Microsoft excel training, Microsoft Excel Training UK · Microsoft courses.

resolvedResolved · Low Priority · Version Standard

Look Up formula for designated details on another sheet

Mabel has attended:
Excel Advanced course

by - delegate Mabel [1 post] (2006 Nov 28 Tue, 18:11) replyReply

I have some data on hidden sheets (details page) and I have a front page where I input certain details for it then to bring up data from the details pages at the back fo my work sheet. I know that the formulas are "look ups" but when I type in the look up formula associating it with the data at the back it doesn't work. Can you help me? Perhaps explain to me the formula for "look up"?
Thanks
Mabel

Excel VBA 2 day course List price £495
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003/XP 2008 May 15 Thu + 16 Fri Bloomsbury 4 book now £475 £485
2003/XP 2008 May 22 Thu + 23 Fri Southwark 5 book now £450 £485
2003/XP 2008 Jun 5 Thu + 6 Fri Bayswater 7 book now £345 £399
2003/XP 2008 Jun 12 Thu + 13 Fri Bloomsbury 6 book now £450 £485
2003/XP 2008 Jun 19 Thu + 20 Fri Southwark 7 book now £345 £399
2003/XP 2008 Jul 3 Thu + 4 Fri Southwark 6 book now £450 £485
Full Schedule: See all 66 Excel VBA course dates.
Bookings currently available until 26th November 2009.

RE: Look Up formula for designated details on another sheet

by - trainer Orok bronze contributer[29 posts] (2006 Nov 30 Thu, 15:09) replyReply


Hi Mabel,

In your question You have not specified if your using the VLOOKUP, HLOOKUP or LOOKUP function

But typically they all require the data being searched (your details page) to be in the first column or row of the details pages and sorted in ascending order.

Regards







Related articles

· Do You Really Need Excel VBA Training?
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· What's Better Than the Help Function in Excel? Microsoft Training
· A Beginners Guide To Formulas In Excel

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information