Skip to content

Excel – combination vlookup & hlookup

November 15, 2014

Done in Excel 2013, (should work with previous versions), this shows how to do a look up of data stored in a grid. The example shows days of the week and seminars offered with #s of attendees.

In addition, learn a shortcut to name ranges and data validation using predetermined lists.  The example shown is a small one yet can be used for large grids of data.

 

Advertisements

From → Excel

Leave a Comment

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

%d bloggers like this: