Hi !

I have a 2 worksheets with data,
worksheet 1
col A Col b colC
point location value
1 3 a
1 4 a
2 5 b
3 3 b
3 6 a
4 4 c
5 15 d

worksheet 2
colA col B
point location
1 1
1 2
1 3
1 4
1 5
1 6
2 1
2 2
2 3
2 4
2 5
2 6
2 7
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
3 9

Basically i want to include a third column in worksheet 2, which indicates the position of the value from worksheet 1 . so basically my output should be something like this.
worksheet 2
colA col B col c
point location Value
1 1 -
1 2 -
1 3 a
1 4 a
1 5 -
1 6 -
2 1 -
2 2 -
2 3 -
2 4 -
2 5 b
2 6 -
2 7 -
3 1 -
3 2 -
3 3 b
3 4 -
3 5 -
3 6 a

So the second worksheet is just an expanded version of the first, i would just like to indicate at which position the value is found for each point. My data base is huge, so i was wondering if any formula could be applied instead of entering it manually.

Value a is found in the third position for the first point in the first worksheet, so i have put the value a against position 3 for point 1 and so on.

Thank you for your help in advance

Nitya