Excel VLOOKUP in Different Ranges

You can use the VLOOKUP function to find data in a lookup table, based on a specific value. If you enter a product number in an order form, you can use a VLOOKUP formula to find the matching product name or price.

In some Excel workbooks, you might need to pull data from a specific table, depending on an option that the user has selected.

For example, in the screen shot below, there are different rate tables for the East and West regions. Range B3:C6 is named Rates_East and range E3:F6 is named Rates_West.

Create the VLOOKUP Formula

On

Continue reading Excel VLOOKUP in Different Ranges

Related Posts Plugin for WordPress, Blogger...

Share and Enjoy

  • Facebook
  • Twitter
  • LinkedIn
  • Google Plus
  • Pinterest