Hey everyone, im looking to create a group of cells to search a table and return what it finds, in my case there may be multiple results.
here is the formula im using that searches the table for text in a certain cell then returns text from the cell next to the keyword
=IF(ISNA(VLOOKUP(a3, ai2:ak34, 2, FALSE)),"",VLOOKUP(a3, ai2:ak34, 2, FALSE))
a3= desired search keyword
ai:ak34 = the table i want to search
2=what column in the table i want the search to return with
like i mentioned my issue comes down to when the text in "a3" is mentioned more than once, the only answer i get is the first one it finds, and in my case it would be inconvenient to break down the table and make multiple searches.
Thank you in advance