IF Function and ignore if

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.
 
M

Mike H

Hi,

Try this

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

where somevalue is what you arelooking for in Col A.

Mike
 
Top