A
Anthon
A B C D
ROW 5 1 65 6 56
ROW 6 2 100 7 41
ROW 7 3 34 8 32
ROW 8 4 6 9 43
ROW 9 5 8 10 5
I have 4 columns as above in one sheet, I want to match the numbers 1 to 10
and return the values in the column matching the number in another sheet as
below. Please note, the above format changes on a daily basis as it comes
from a web query e.g tomorrow there might only be 8 numbers, in which case 5
in A9 will move to C5 and A9 and C 9 will then be blank.
A B
ROW 5 1 65
2 100
3 34
4 6
5 8
6 56
7 41
8 32
9 43
Row14 10 5
The formula should be in B5 through B14 , is this possible? Thanks. Anthon.
ROW 5 1 65 6 56
ROW 6 2 100 7 41
ROW 7 3 34 8 32
ROW 8 4 6 9 43
ROW 9 5 8 10 5
I have 4 columns as above in one sheet, I want to match the numbers 1 to 10
and return the values in the column matching the number in another sheet as
below. Please note, the above format changes on a daily basis as it comes
from a web query e.g tomorrow there might only be 8 numbers, in which case 5
in A9 will move to C5 and A9 and C 9 will then be blank.
A B
ROW 5 1 65
2 100
3 34
4 6
5 8
6 56
7 41
8 32
9 43
Row14 10 5
The formula should be in B5 through B14 , is this possible? Thanks. Anthon.