If anyone could help me with my problem it would be much appreciated.
I want in Excell to be able to type in a name for instance and have all the details for that person be put onto my sheet.
For example i type in John Smith, and it would automatically bring up his company name and address in the cells below.
Is this Possible?
if it is how would i do it?
I know i would need all those details somewhere else so that it can retrieve these details from somewhere but i dont know how this formula would work to be able to basically choose from a long list of names to match the 1 that 1 want.
Please could someone help me and let me know if this is possible
Thank you