Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her:
http://www.contextures.com/xlFunctions02.html
VLOOKUP

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"GregA" wrote:
I am trying to find a way to pull certain data off a particular sheet
onto a new sheet. I don't think I need a macro and can do it through
VLOOKUP or a IF function. Would be good if someone could give me some
help on this.

Essentially I want to pull the data in columns A, B and I into a new
worksheet. But I only want to pull these cells when in column H it says
2.

So i guess Im saying in the new worksheet, pull data in columns A,B and
I, only if in column H it says 2.

If anyone could give me a hand, I would be most grateful. Many thanks
for your time,

Greg.