Solved

# Vlookup + offset problem

Posted on 2013-01-25
277 Views
Hi Experts,

How can i get the value 1 row below the cell that contains the value in this Lookup:
=VLOOKUP(\$B2,sheet1!\$B:\$L,2,FALSE)

Thanks,

Tom
0
Question by:tomfolinsbee
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 38818738
Try:

=INDEX(sheet1!\$B:\$L,MATCH(\$B2,sheet1!\$B:\$B,0)+1,2)
0

Author Closing Comment

ID: 38820966
Thank you!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
###### Suggested Courses
Course of the Month2 days, 2 hours left to enroll

#### 717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.