D
dab
Good day,
Thanks for looking
I have the following dilema
Column A has 782 cells ramdomly filled with numbers between 1 and 150
Column B is an ascending list from 1 to 150
Column C has random values for each cell on column B
Will it be possible to show me how to scan column A and for each value
encountered, do a match on column B and upon matching it, post the
corresponding value on column C on say column D?
Example:
origin
----A-----B-----C
1-- 4---- 1 ----4.56
2-- 1---- 2 ----2.36
3-- 2---- 3 ----1.23
4-- 2---- 4 ----6.52
Result
----A-----B-----C-----D
1-- 4---- 1 ----4.56--6.52
2-- 1---- 2 ----2.36--4.56
3-- 2---- 3 ----1.23--2.36
4-- 2---- 4 ----6.52--2.36
Thanks for your help
Regards
Thanks for looking
I have the following dilema
Column A has 782 cells ramdomly filled with numbers between 1 and 150
Column B is an ascending list from 1 to 150
Column C has random values for each cell on column B
Will it be possible to show me how to scan column A and for each value
encountered, do a match on column B and upon matching it, post the
corresponding value on column C on say column D?
Example:
origin
----A-----B-----C
1-- 4---- 1 ----4.56
2-- 1---- 2 ----2.36
3-- 2---- 3 ----1.23
4-- 2---- 4 ----6.52
Result
----A-----B-----C-----D
1-- 4---- 1 ----4.56--6.52
2-- 1---- 2 ----2.36--4.56
3-- 2---- 3 ----1.23--2.36
4-- 2---- 4 ----6.52--2.36
Thanks for your help
Regards