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.

Resolved · 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) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	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) Reply

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

· 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

secure online payments - visa - mastercard

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

Training by application

Main information pages

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

Related articles

Excel tip:

Entering text in Multiple Worksheets