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.