IF Function and ignore if
 

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.

IF Function and ignore if
 

Hi,

Try this

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

where somevalue is what you arelooking for in Col A.

Mike

"Hicks" wrote:

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.