HLOOKUP

Resolved · Medium Priority · Version 2010

Thu 31 May 2012, 11:37 Delegate Lesley said...

Lesley has attended:
Excel Advanced course

HLOOKUP

I am trying to look up job numbers allocated to a mobile number from a worksheet and make it appear in a different workshhet that contains the mobile number and other information.
The mobile number may have a number of job numbers allocated to it, can I ask it to only pick up the most recent job number?? if so how?

Fri 1 Jun 2012, 09:47 Trainer Andrew said...

RE: HLOOKUP

Hi Lesley

Thank you for your question. I think the key here would be to make sure that your data (the job numbers associated with the mobile phone numbers) is sorted in most recent date order. That way when your lookup finds its match on the mobile number the corresponding job information is for the most recent activity. I've tested with a small example and it seemed to work OK with an exact (false) match.

Perhaps you could test with a small sample of data and let me know if this answers your question. Let me know how you get on.

Kind regards,
Andrew

Fri 1 Jun 2012, 10:03 Delegate Lesley said...

RE: HLOOKUP

Thank you this now works for me as well I have also named the fields which has helped

Kind regards

Lesley

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

HLOOKUP

HLOOKUP

RE: HLOOKUP

RE: HLOOKUP

Excel articles

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010