I am not sure how to do this, I have spreadsheet attached, which has search function and shows matches based on search column B ( Name). The idea is to also search base on the column C (Other Name) as search criteria?? SO either Column B or Column C should search the same record and show in the list box. Currently, only Column B is coded in the spreadsheet, would need help with adding Col C to gives the same record in listbox??? Then,
Upon finding the desired item in the listbox for example "John Cona" or "jc", click on the record "John Cona" from the listbox and USERFORM2 gets open and shows the results in the corresponding textboxes already designed in the excelsheet as USERFORM2.
Would highly appreciate your expertise and help here with the code....
many thanks in advance.