I am using the vlookup function with wildcards to search column A to find the adjacent value in column B. This function works, but I need to expand it to return all the matches (for partial searches). Additionally, I would also like to include the value from column A in the same cell the result(s) are returned (for side by side comparison).
Any ideas how I could do this without using any macros?
So, the function is in C2 and the search term is in C1
=VLOOKUP(C1&"*",$A$2:$B$42,2,FALSE)
Any ideas how I could do this without using any macros?
So, the function is in C2 and the search term is in C1
=VLOOKUP(C1&"*",$A$2:$B$42,2,FALSE)