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?
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
