Hi ! I want to do as follows: I work in another worksheet than the data.
Wanting to find the same 6-digit number in the other worksheet and return the
value from column B to the other worksheet. that works when the 6-digit no.
appears in one row. But for th no: 879048 I would like to return the sum of
the three rows, in total 7618 - how can I do that? I use Office 2003

=LOOKUP($A8;$A$2:$A$5;(B$2:S$5))
=LOOKUP($A9;$A$2:$A$5;(B$2:S$5))
A B
1 UB
2 87 90 48 3806
3 87 90 48 2156
4 87 90 48 1656
5 87 90 51 1856
6
7 another worksheet
8 87 90 48 N/A I can not get the sum of 7618 to this cell
9 87 90 51 1856 works OK