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

Hi

I am trying to find a way to pull certain data off an existing worksheet and onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or an 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 on the existing sheet into a new worksheet. But I only want to pull those 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. (obviously it would then pull those 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 thanks for your time,

Greg.

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

etc.
--
Brevity is the soul of wit.


"Gregula" wrote:

>
> Hi
>
> I am trying to find a way to pull certain data off an existing
> worksheet and onto a new sheet. I don't think I need a macro and can do
> it through VLOOKUP or an 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 on the
> existing sheet into a new worksheet. But I only want to pull those
> 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. (obviously it would then pull those
> 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 thanks
> for your time,
>
> Greg.
>
>
> --
> Gregula
> ------------------------------------------------------------------------
> Gregula's Profile: http://www.excelforum.com/member.php...o&userid=37728
> View this thread: http://www.excelforum.com/showthread...hreadid=573162
>
>