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

vlookup formula to pull data between two dates

Posted on 2016-10-04
Last Modified: 2016-10-04
Hi Experts Using Excel 2010

i have the following array formula which works within the worksheet but not when the formula is add to another worksheet....
=INDEX('Data Entry'!BF$19:BF$531,SMALL(IF('Data Entry'!$BF$19:$BF$531>=$C$1,IF('Data Entry'!$BF$19:$BF$531<=$F$1,ROW('Data Entry'!$BF$19:$BF$536)-ROW('Data Entry'!$BF$19)+1)),ROWS(C$6:C6)))

cannot see the error....
Question by:route217
  • 3
  • 2
LVL 30

Accepted Solution

Subodh Tiwari (Neeraj) earned 500 total points
ID: 41827657
Make the range reference identical in the formula....
ROW('Data Entry'!$BF$19:$BF$536) should be ROW('Data Entry'!$BF$19:$BF$531)

Author Comment

ID: 41827663
Supper star.....doh!!! On my part..thanks

Author Comment

ID: 41827664
Posting part two..
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41827747
You're welcome.

Author Comment

ID: 41827758

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

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

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

Join & Ask a Question