one way looking for 46 in col E and numbers in columns H:I
=SUM(INDIRECT("H"&MATCH(46,E:E)&":I"&MATCH(46,E:E)))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"holcay" <holcay@discussions.microsoft.com> wrote in message
news:2D1B00BD-D4CE-4B67-938D-F890D70F90EB@microsoft.com...
>I am trying to investigate a way in which I can get V-Lookup to sum the
> values and bring back the total figure when more than one cell matches the
> search criteria. E.g. if I am getting it to search for number 46 and I
> want
> it to bring back the next column, and there are two 46 matches, and each
> of
> the columns I want to bring back having a number in there, I want it to
> sum
> the two numbers and bring back the total figure.