hi guys,

i have two sheets, one to display results (Reults tab) & the other tab
containing the data (Data tab)

what i am trying to do is some how create a search function and have a
forumula which contains a LIKE function that looks up the data table
RANGE = Data!A2:K255

the search needs to lookup the primary column Data!B2:B255 ... if any
results are found .. show them on the results tab.. and if multiple
results are found, display those as well.. (in either instance, the
whole row of information in respect to the results need to be dislayed
and hopefully no duplicates are found .. eg, Data!A:K of a hit)

is there a formula that can achieve this? oh, the search is TEXT based
and there should be no empty cells within the dataset

cheers & thanks for your assistance