I know,
I've seen plenty already, but for the life of me, I don't understand how the INDEX/MATCH formula applies for my question, and the concecate method returns irrate values.
I want my suppliers to fill in the
Colomn A: Client #
Colomn B: Subdivision
And magically they will have the Client name appear in Colomn C.
My array table is on sheet 2, hidden, A2:C472.
I haven't placed this on my exemple, but I have data validation from a list (of unique records) for my client # and Subdivision. I don't think it will affect anything though.
Can anyone help me on this?
Bookmarks