VLOOKUP to ignore lines which do not meet criteria
 

I'm using VLOOKUP to import data from a pivot table. Currently I have
set it up so that VLOOKUP uses the row names and the count with an IF
forumla to import anything above a count of 12. I have the following
formula:

IF=('[Alarm log.xlsx]Aug'I$B:$V=12,'[Alarm log.xslx]Aug'I'$B,"")

This is working perfectly BUT instead of bringing over data which
looks like this:

ROW NAME COUNT
ROW NAME COUNT
ROW NAME COUNT

It is bringing over data which looks like this:

ROW NAME COUNT
BLANK LINE (because it does not meet criteria)
ROW NAME COUNT
ROW NAME COUNT

I would like it to NOT insert the blank line i.e. completely ignore
data which does not meet its criteria.

Any help appreciated!

VLOOKUP to ignore lines which do not meet criteria
 

An easy way is just to apply autofilter to that column and select Non-
blanks from the filter pull-down.

Hope this helps.

Pete

On Aug 18, 9:53*am, Custard Tart wrote:
I'm using VLOOKUP to import data from a pivot table. Currently I have
set it up so that VLOOKUP uses the row names and the count with an IF
forumla to import anything above a count of 12. I have the following
formula:

IF=('[Alarm log.xlsx]Aug'I$B:$V=12,'[Alarm log.xslx]Aug'I'$B,"")

This is working perfectly BUT instead of bringing over data which
looks like this:

ROW NAME COUNT
ROW NAME COUNT
ROW NAME COUNT

It is bringing over data which looks like this:

ROW NAME COUNT
BLANK LINE (because it does not meet criteria)
ROW NAME COUNT
ROW NAME COUNT

I would like it to NOT insert the blank line i.e. completely ignore
data which does not meet its criteria.

Any help appreciated!