same way.
or am i missing something?


change abc to Abunayyan and klmn abcdef sdfg thylll to A Abunayyan Trading Company in the code i posted.

it will return A Abunayyan Trading Company from A14.

but if any cell above it, say A5, contains Abunayyan, for ex Abunayyan Home Appliances, this time it will return value from A5.

if you want A Abunayyan Trading Company get returned, you should change the search string to Abunayyan Trading, etc.