Good Day,
I have a workbook (attached). On sheet 2 "DATA" is al my major data. Divided by Info and reference columns.
On sheet 1 "INFO" I have a search bar and a space for results.
Now, All I need is a formula, or VBA or advanced Filter (whichever works best) that allows me to do the following:
- When info is put in cell C2 of INFO sheet., I want it to search all references of that text or number string in the REFERENCE columns of the DATA sheet.
- It should then list the values in column A and B on the INFO sheet (Under results)
- If there are numerous results, I would like it if it shows them all listed there.
Any and all help would be greatly appreciated!
Bookmarks