Hi all
I have the folowing layout
J1 = "Nr. 8" K1 = "Bl. 44" L1 = "Sc. b" M1 = "Ap. 33"
The above is not always in this order. I need a formula that will search the range J:M for a case insensitive string and return the found value as result.
I tried the folosing but it doesn;t suit my needs
Thank you![]()
=IF(FIND("Nr",J1,1),J1)
Bookmarks