Complicated lookup/match formula help needed!
I see that my formatting got messed up on the post. This should be
columns BA:BJ for the ID numbers (with a dash), columns BK:BP for
#visits, and columns BQ:BV for #Individual. There are 6 columns for
visits and 6 for individual because at most the 6th column of ID#s has
a number entered.
I'd really appreciate any help with this!
Thanks,
Jason
I would LIKE the ClientList sheet to look like this (column A is
already filled with the ID numbers, I just need to match the other
fields):
VISITS INDIVIDUAL
A B C
4-2 5 1
3-2 4 2
1-9 3 0
2-2 2 1
3-3 1 3
4-5 11 4
5-1 8 0
1-1 1 1
...
Thanks for any suggestions!
Jason
|