Not sure what you mean, but do look he

http://office.microsoft.com/en-us/as...260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jen" wrote in message ...
|
| Is it possible to do a formula within a VLOOKUP when the return answer could
| be more than one thing.
| I.e., if I have a list of property numbers but there are several lease
| numbers for each one. I only want to pull back property 123 is it has lease 4
| as well. It may have lease 1, 2, 3. Normally with a vlookup it brings back
| only the first answer whereas I need to lookup the answer too.
| If that makes sense...