Match two values and return ticker

New Contributor

I need a formula that will match two values and return the corresponding ticker into column H (highlighted)


name2 finds a match in name1 where it then returns ticker1 into the column of ticker1


Match Two Values and Return Ticker.xlsx



1 Reply
best response confirmed by packie (New Contributor)



You can try INDEX and MATCH. If you add IFERROR you can remove error messages if there isn't a match. An alternative could be VLOOKUP. If you work with Office365 or Excel 2021 you can apply XLOOKUP as well.

index match.JPG