VLookup & HLookup functions

Hi Michael


Thank you for your question.

The lookup functions are used to retrieve data, there are many lookup functions with VLookup (vertical lookup) & HLookup (horizontal lookup) being two of them.
An example of how a lookup function may be used:
On one worksheet you have information of employee names & departments.
On a second worksheet you may have information on the departments including manager names.
Using a lookup function you would be able to retrieve the department manager name and place it in the first worksheet without copying & pasting.

Please see the link below for further information.

http://www.mrexcel.com/tip096.shtml

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.


Regards,


Nafeesa

Microsoft Office Specialist Trainer