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...