Hi,
I've been able to do this myself but over many columns!!!
I was wondering if there is a simpler way please.
Here is an example:
In K1:K15 I have numbers I would like to use to lookup the "values" in column L9:L15. There are two of each number in K1:K15 starting from 1.
From row 18 to 21 I would like for example (the first line) "1" in K18 to lookup and get the first "1" in K9:K15 and place that value 1000 in L18 and the second occurence of "1" which is 5000 into M18.
Bit of a puzzle! Hope I didn't confuse too much.
Cheers Janet
I've been able to do this myself but over many columns!!!
I was wondering if there is a simpler way please.
Here is an example:
SW3.8.xls | ||||||
---|---|---|---|---|---|---|
K | L | M | N | |||
8 | Number | Value | ||||
9 | 1 | 1000 | ||||
10 | 2 | 2000 | ||||
11 | 3 | 3000 | ||||
12 | 2 | 4000 | ||||
13 | 1 | 5000 | ||||
14 | 4 | 6000 | ||||
15 | 3 | 7000 | ||||
16 | ||||||
17 | Number | Value1 | Value2 | |||
18 | 1 | 1000 | 5000 | |||
19 | 2 | 2000 | 4000 | |||
20 | 3 | 3000 | 7000 | |||
21 | 4 | 6000 | ||||
For O-C Eq |
In K1:K15 I have numbers I would like to use to lookup the "values" in column L9:L15. There are two of each number in K1:K15 starting from 1.
From row 18 to 21 I would like for example (the first line) "1" in K18 to lookup and get the first "1" in K9:K15 and place that value 1000 in L18 and the second occurence of "1" which is 5000 into M18.
Bit of a puzzle! Hope I didn't confuse too much.
Cheers Janet