G
Guest
My Vlookup formula returns the name of the person within a cost centre.
However if there are two people within the cost centre it obviously doesn't
return the second persons name.
I want to have a second Vlookup formula (in another cell) which will pick up
the name of the second person within the cost centre (there will no more than
2 people), or simply nothing if there is only 1 person within that cost
centre.
How can I do this?
Thanks in advance of your help
However if there are two people within the cost centre it obviously doesn't
return the second persons name.
I want to have a second Vlookup formula (in another cell) which will pick up
the name of the second person within the cost centre (there will no more than
2 people), or simply nothing if there is only 1 person within that cost
centre.
How can I do this?
Thanks in advance of your help