Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Vlookup In MS Excel 2007

Lets talk today about performing vlookup in MS Excel 2007. Here we will explain how to do a vlookup on the same page and how to do a vlookup on different sheets. Before we start there are a few ground rules: • In order to do a vlookup most important is that the variable on which you are doing a vlookup is to the left of the variables you want to bring out. • The variable should be of the same format as required in the output. • Vlookup always happens from left to right and not vice versa. • Always ensure that the range on which vlookup is done is an absolute cell reference.

Now lets start. Here we have two sheets called the “Base Sheet” and the “Output Sheet".

Once you have locked the cells as an absolute cell reference, copy and paste the formula in the rows below. Now you are done with the vlookup. All the data is now available in the format you wanted.

Now, in order to do a vlookup on a different sheet or on a different file use the same method. The only difference would be while doing on a different sheet it will give the reference of that sheet or that file from where we are doing the vlookup. Also do keep a check on that you have locked the cells of the range from where you are doing the vlookup.

Once you are done with the vlookup in a cell on a different sheet, copy and paste the same formula in the other rows as shown below.

0 comments:

Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits