Stclements1
Board Regular
- Joined
- Sep 15, 2018
- Messages
- 158
- Office Version
- 365
- Platform
- Windows
Can anyone help me please, I have to arrays of numbers each array has 12 numbers, the numbers in array 1 are equal to a numeric value in aray 2.
Example
cell j10=1 if cell j10 =1 then cell h10=4373
cell j11=5 if cell j10 =5 then cell h11=600
and so on for j10:j22 and H10:h22.
I tried to write and index statement and an nested if statement but neither seem to work.
Example
cell j10=1 if cell j10 =1 then cell h10=4373
cell j11=5 if cell j10 =5 then cell h11=600
and so on for j10:j22 and H10:h22.
I tried to write and index statement and an nested if statement but neither seem to work.