connecting multiple cells to new sheet (VLOOKUP?IF?)

[Gregula]

Hi

I am trying to find a way to pull certain data off an existin
worksheet and onto a new sheet. I don't think I need a macro and can d
it through VLOOKUP or an IF function. Would be good if someone coul
give me some help on this.

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

So i guess Im saying in the new worksheet, pull data in columns A,B an
I, only if in column H it says 2. (obviously it would then pull thos
three columns into columns A,B and C in the new worksheet!).

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

Greg

 

[Dave F]

Well, you could write a formula, say =IF(sheet1!H2=2,sheet1!A1,"")

etc.