Solved

vlookup formula to pull data between two dates

Posted on 2016-10-04
5
60 Views
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....
Array
=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....
0
Comment
Question by:route217
[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
  • 3
  • 2
5 Comments
 
LVL 30

Accepted Solution

by:
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)
0
 

Author Comment

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

Author Comment

by:route217
ID: 41827664
Posting part two..
0
 
LVL 30

Expert Comment

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

Author Comment

by:route217
ID: 41827758
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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