VLOOKUP to ignore lines which do not meet criteria

  • Thread starter Thread starter Custard Tart
  • Start date Start date
C

Custard Tart

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!
 
An easy way is just to apply autofilter to that column and select Non-
blanks from the filter pull-down.

Hope this helps.

Pete
 
Back
Top