I am using Excel 2007.
I have a workbook with multiple sheets. Sheet1 is my lookup page, Sheet2 is my data. I have attached an example. I was given this by co-worker thinking it would return multiple entries, but only comes up blank.
My goal is to search similiar names or variations of a name to return all the LOC (Col A) options.
When I use this formula I figures out, it only returns the last one found: =LOOKUP(2^15,SEARCH(H13,D3:D11),A3:A11)
Can anybody assist this newbie?