Thanks,

Looking for it to look in range e1:h5 pick match for b9 then find name from name column b2:b5. Then put found name into A9.

Need forumla to do the above without changing sheets layouts.

Thanks for your input appreciated.