There are two sets of data with one field matching in both sets. I want to
be able to put a formula into a cell and find the matching field, whether it
is in cell 10 or cell 1000. I've tried vlookup, but I'm not getting the
results I was looking for. Any other suggestions.