If cell contains a specific test teh copy it to a cell in another sheet

  • Hi People.


    So what I'm trying to do is I have a list of names in A and in E I have their Grades.


    What I'm trying to do is in another sheet it looks like


    A B
    [TABLE="width: 207"]

    [tr]


    [td]

    HA 10

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 9

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 8

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 7

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 6

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 5

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 4

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 3

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 2

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    HA 1

    [/td]


    [td][/td]


    [/tr]


    [/TABLE]


    What I want to do is in Column B on Sheet 2 is to look through and find any Matching Grades on Sheet 1 Column E and place the name from Sheet 1 Column A into the cell.
    The problem I'm facing is I can write it to write down multiple names as some times people will have the same grade

  • Re: If cell contains a specific test teh copy it to a cell in another sheet


    You have your sample workbook? To avoid us to re-typing again your data, click "Go Advanced" button and find Paperclip Button to attach your file.


    regards

  • Re: If cell contains a specific test teh copy it to a cell in another sheet


    Anybody got any ideas.I'm still stuck with this.

Participate now!

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