Quote Originally Posted by Musiclover119 View Post
Thx Guys,

why do I put " Rows($1:1)" into column_num?
It is just because when formula will go down Rows($1:1) change into Rows($1:2) that means 2 and Index array will understand now second column which column B need to work.

I had use match the alphabet and let consider in which column that particular alphabet is stand instead of rows

Hope you understood..