I have an index match formula that is sometime giving correct data, sometime incorrect data and sometime #N/A.
I have the complete list of clients in column A. I want column B to provide the assigned Unit # and then column C to give the unit leader. Column D I have listed some notes as to what Column B & C should state.
Can you help me fix the formulas in column B and C? Document attached
Bookmarks