In sheet Canberra, use this formula in all cells in columns A:F.
=INDEX(Data!$A:$F,SMALL((100-(99*--(SEARCH("canberra",Data!$A$1:$A$200&"canberra")<LEN(Data!$A$1:$A$200))))*ROW(Data!$A$1:$A$200),ROW()),COLUMN())
Change the two constant strings to "sydney" for the other sheet, as in the attached.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you again...however it isn't working. The result I got was zero..literally 0 in the cell.
Sheesh...maybe this won't work.
Is there anyone that has a solution to this issue? It is urgent that I find an answer. I just want a formula to search and return a "partial" match on a list.
I have tried the offered formula in the sample workbook, works fine in there. But the minute I transfer it to my book, (changing the cell references of course) and YES I did control, shift + enter after editing) but it still will not work no matter what I do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks