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

ResolvedVersion Standard

Tue 28 Nov 2006, 18:11 Delegate Mabel said...

Mabel has attended:
Excel Advanced course

Look Up formula for designated details on another sheet

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

Thu 30 Nov 2006, 15:09 Trainer Orok said...

RE: Look Up formula for designated details on another sheet

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