J
Jeremy
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
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