getting data from Reference Sheet

  • [SIZE=13px]Below is a diagram of sheet 1 ( reference sheet) and sheet 2, I would like to have info on sheet 2 to only show if column H from sheet 1 is AA, not sure is a vlookup or if/or formula is best, any help much appreciated[/SIZE]


    . .A ...B .C...D.. ..E ...F ….G.... H

    [SIZE=13px]1 BL CD RF .WW ZZ. JK,,……...AA
    2
    [/SIZE]


    [SIZE=13px]3 QI .PP LY .MN .FG DD... JJ.. CE[/SIZE]


    [SIZE=13px]4 SD JH. II .YR. ES. VO ...LJ...AA[/SIZE]



    [SIZE=13px]Sheet 2[/SIZE]


    [SIZE=13px]. ..A.... B... C.. D....E.... F.. G.. H[/SIZE]


    [SIZE=13px]1 .[/SIZE]

    BL .CD .RF .WW. ZZ .JK......AA
    2
    3
    4.SD. JH.. II.. YR.. ES. VO..LJ.. AA

  • I'd use a simple IF formula, e.g., in A1 on Sheet 2: =IF(Sheet1!$H1="AA",Sheet1!A1),"")


    Then you can just copy that across to column H and down the number of rows used.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!