How to use VLOOKUP in Excel

One of the most useful features in Excel that you should be using, and here’s why.

 

Let’s say that there are 2 great reports that you can get from you donor data base.  The first report lists constituents by giving capacity and city.  The 2nd report lists donors by lifetime giving history.  Let’s say you want to put the reports together to be able to have giving history and giving capacity.  If you have an unique ID, VLOOKUP makes it easy!

 

In my example, the syntax is

=VLOOKUP(Sheet1!A1,Sheet2!A1:B5,2,false)

and here’s what that means — there are 4 parts to the formula:

part 1: use constituentID located in cell A1 in my current sheet as the reference

part 2: look into a range of columns/ rows in another sheet that also includes the ID

part 3: return the value to import from the 2nd column in the other sheet

part 4: default to false and make sure both sheets are sorted.

 

Try it yourself and you’ll figure it out in just a few minutes and feel awesome for the rest of the day!

signature2

 

 

 

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s