I am tring to transfer data from one worksheet to another given certain
criteria using a formula. Below is an example.


Sheet one
a b
1 400 016
2 400 017
3 1028 0143
4 4567 0252
5 23949 110


Sheet two
a b c
1 400 016 car126
2 400 017 car127
3 1028 0143 car128
4 4567 0252 car129
5 23949 1101 car130


Sheet one results after formula.
a b
1 400 016 car126
2 400 017 car127
3 1028 0143 car128
4 4567 0252 car129
5 23949 110 car130