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
: 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]