• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
WittySparks Logo White

WittySparks

Ignite Your Thoughts

  • Topics
  • Reviews
  • Newsletter
WittySparks / Technology / Software / Using Vlookup for multiple sheets in Excel 2007
vlookup across multiple sheets i

Using Vlookup for multiple sheets in Excel 2007

Software April 29, 2009 by Kartik Subramaniam

Vlookup is one function that is widely used across excel users. However, for those who are beginning to use Excel, this post will give a few tips on how to use Vlookup across multiple sheets. So, before we begin, here is a brief intro about what vlookup does.

The function is used to retrieve values corresponding to a particular value. This value might be in a particular sheet or in some other sheet. It is the latter that shall be looked into in this post.

Let’s say there are a series of values in a sheet- Temp1.xls in the following manner.

vlookup-across-multiple-sheets_i

Now say there is a series of values in another sheet named, Sheet 2

vlookup-across-multiple-sheets_ii

Tiger is an entry that is there in the file temp2.xls and also present in file temp1.xls; say you want to find the value corresponding to the tiger in file temp1. Before you type the formula in the formula bar of file temp2.xls, make sure you have saved the file from which you want values to be searched!

Having saved the file, now for the formula:

(i) For the first parameter- Type the formula =vlookup(“tiger”,

vlookup-across-multiple-sheets_i

(ii) For the second parameter- press ctrl+pagedown and switch to the file where the entry is present, select the table i.e. which would get selected in the following manner:

vlookup-across-multiple-sheets_iii

(iii) Now complete the formula =VLOOKUP (“Tiger”,Sheet1!G3:H10,2,0). This would throw the value corresponding to Tiger in the second row, which is Tim in the desired cell.

In case of multiple files, don’t forget to save the files

Press the AL+ tab to switch to the file where the source table is located,

Select the table and enter the column number whose value corresponding to the value entered in the formula is needed

In plain words, follow the above-mentioned steps, and you will get your desired result!

For more tips on excel watch out for this space.

Related Topics

  • FlexClip Review: Is it the right tool for Video Creators?
  • Hubstaff Review: Is it the best time tracking tool?
  • Website Analytics: Almost Everything You Need To Know
Previous Post: « Here is our new WittySparks CSS Framework
Next Post: Google Wave – new wave in communication? »
Profile picture for Kartik Subramaniam

About Kartik Subramaniam

A dreamer of sorts & a Creative writer, passionate about reading diverse stuff.

View all posts by Kartik Subramaniam

Primary Sidebar

Search

Exclusive Coupons

  • Moqups coupon code: WITTYSPARKS for 20% or PARTNERS50 for 50% discount.
  • WPForms coupon code: WITTYSPARKS for 50% off.
  • Serpstat coupon code: wittysparks_discount for 30% off.
  • SEO Buddy coupon code: WITTYSPARKS for 25% off.
  • Morningscore coupon code: wittysparks for 30% off for 3 months.
  • FlexClip coupon code: WITTYSPARKS for 30% off.
  • Uplead coupon code: “witty” for 30-day free trial.
  • FastestVPN coupon codes: WITTYSPARKS15 or WITTYSPARKS10 or Get up to 93% OFF.
  • Outranking.io coupon code: WITTYSPARKS50 for 50% off.

For more such offers visit our exclusive offers for SEO, Bloggers, Marketers and for Business owners.

Featured Productivity Software

Notion logo
Notion

Whether you’re a solo entrepreneur or a large team, Notion Workspace can help you stay organized and get more done. Get started today and take your productivity to the next level.

Try Notion for FREE

Footer

Affiliate Disclosure

If you make a purchase from WittySparks links, we will receive a small commission. See our Affiliate Disclosure.

Sponsors

Partnered with FreePik to use the licensed images.

turn to dhgate for smartphone

Follow Us

  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
  • Instagram
  • YouTube
  • RSS

Copyright © 2023 · Hosting sponsored by Rocket.net (Affiliate link)

  • About Us
  • Contact Us
  • Privacy Policy
  • LinkedIn
  • Twitter
  • Like
  • Pinterest