On Jul 14, 3:15*am, Ayobami Adeloye wrote:
Hi all, i need help. I am working with two different list of assets, i
am trying to populate one of the lists with data from the other list.
i have tried using vlookup, but the problem i have is that i am using
the description of the assets as the search criteria, but i have
situations where i have the same description for more than one asset,
so when using the vlookup function, it returns the same value for the
first of the occurnece for all the values with the same description,
is there anything else i can do.

Thanks for your anticipated help.

Post samples or

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."