Can someone please provide an Excel formula to do this using one or more of the lookup Columns 1, 2 and/or 3 so the large numbers are repeated below each where the ''1s' or '1 to 9s' appear in Columns 2 or 3 respectively - Formula in Column4? (the following is just a sample. I would like all the numbers in Column1 to do this eventually...
Column1 Lookup | Column2 | Column3 | Column4 |
106 | 106 | 106 | Formula |
668 | 1 | 1 | Formula |
1964 | 1 | 2 | Formula |
4221 | 1 | 3 | Formula |
5771 | 1 | 4 | Formula |
7641 | 1 | 5 | Formula |
9842 | 1 | 6 | Formula |
12410 | 1 | 7 | Formula |
15350 | 1 | 8 | Formula |
18700 | 1 | 9 | Formula |
26674 | 668 | 668 | Formula |
1 | 1 | Formula | |
1 | 2 | Formula | |
1 | 3 | Formula | |
1 | 4 | Formula | |
1 | 5 | Formula | |
1 | 6 | Formula | |
1 | 7 | Formula | |
1964 | 1964 | Formula | |
1 | 1 | Formula | |
1 | 2 | Formula | |
1 | 3 | Formula | |
1 | 4 | Formula | |
1 | 5 | Formula | |
1 | 6 | Formula |
Last edited: