ExcelBanter - VLookup Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLookup Help (https://www.excelbanter.com/excel-discussion-misc-queries/237678-vlookup-help.html)

Brenda from Michigan

VLookup Help

Excel 2003 SP3

User formula is =VLOOKUP($A30,'ATS '!$A$2:$B$91,2).

In sheet ATS she has data ending on row 74. She has allowed 91 rows to
include new entries as needed in the future. However, the formula works
intermittantly. For some entries she has to change the formula to $B$B80
(give or take a few rows). Is there a limit of blank rows that can be used
in the lookup formula?

Eduardo

VLookup Help

Hi,
try this

=VLOOKUP($A30,'ATS '!$A$2:$B$91,2,false)

"Brenda from Michigan" wrote:

Excel 2003 SP3

User formula is =VLOOKUP($A30,'ATS '!$A$2:$B$91,2).

In sheet ATS she has data ending on row 74. She has allowed 91 rows to
include new entries as needed in the future. However, the formula works
intermittantly. For some entries she has to change the formula to $B$B80
(give or take a few rows). Is there a limit of blank rows that can be used
in the lookup formula?

All times are GMT +1. The time now is 03:10 PM.