Example?

is the data numeric or text. If numeric do you mean you want to sum all the
values in one column where they meet the VLOOKUP criteria (If so then you
really want SUMIF and not VLOOKUP).

Give us some more details, and perhaps an example of your data plus the
desired output so we don't have to guess at what you want to do.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Rashmi" wrote in message
...
I have data where the lookup column has more than one row resulting. I
want
to retrieve all matches and put the result in one cell. Can anyone help?
Thanks!!