Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

Note:
All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog

2/07/2013

Bruyneel: Using Excel Vlookup to match data from datasets

Mark Bruyneel has made a blog items solving the problem of matching result sets (two work sheets within excel) coming from different parts of a database of from two databases. It should save a lot of complex work and frustration (in a worst case one item at a time)

Quote:
Many people use the Excel Vlookup function to merge data from 1 or more sheets and have it presented in a single table for use later. This can be to create a single overview with all the data together from several downloads from 1 or more databases. Alternatively Vlookup can be used to match company identifiers from more than one database as a preparation for an event study

Blog Item

Youtube has got a special channel dedicated to Tips and tricks in excel: Excellsfun. The following movie shows
 Vlookup for beginners


No comments:

Post a Comment