VBA&Excel

Hi, I don't know if this is right place to ask but if someone knows how to do this, please help.

Sheet1 I have list of names (about 200)in columnA and in row 1 ID codes in each column (from col C up).
Sheet2 I have smaller lists, names (5) + corresponding value under ID code. For example column B the list of names and col C row 1 ID code and the corresponding value under it...

Is it possible to have somekind of code that goes through the lists in Sheet2 and finds the right ID code and place (name) in Sheet1 and paste the value from sheet2 into its right place in sheet1.

Comments

  • : Is it possible to have somekind of code that goes through the lists
    : in Sheet2 and finds the right ID code and place (name) in Sheet1 and
    : paste the value from sheet2 into its right place in sheet1.

    Use the function FINDV / FINDH.
    I couldn't understand your explanation completely.
    But you can try this.

    An example:

    =FINDV("12",A2:B21,2,FALSE) ==> "NAME 12"
    [code]A B
    1 NAME 1
    2 NAME 2
    3 NAME 3
    4 NAME 4
    5 NAME 5
    6 NAME 6
    7 NAME 7
    8 NAME 8
    9 NAME 9
    10 NAME 10
    11 NAME 11
    12 NAME 12
    13 NAME 13
    14 NAME 14
    15 NAME 15
    16 NAME 16
    17 NAME 17
    18 NAME 18
    19 NAME 19
    20 NAME 20
    [/code]

    [red]Good luck![/red]
    [blue]Hackman[/blue]
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion