excel training courses london - look up formula designated

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

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

resolvedResolved · Low Priority · Version Standard

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

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







 

Excel tip:

Quickly select a block of data

To quickly select a block of data make sure your active cell is somewhere whithin the block of data and then press Ctrl+* or Ctrl+Shift+8.

View all Excel hints and tips


Server loaded in 0.18 secs.