IF Function and ignore if

  • Thread starter Thread starter Hicks
  • Start date Start date
H

Hicks

Hi there

I need a If statement to Extract data in a worsheet array column B IF COLUMN
A IN THAT Worksheet meets a certain condition else the if statement must
ignore those that does not meet the condition and loop to the next row that
meets the condition.
 
Hi,

Try this

=VLOOKUP(somevalue,A1:B100,2,FALSE)

where somevalue is what you arelooking for in Col A.

Mike
 
Back
Top