Forum Discussion
Solved
Match two values and return ticker
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
=IFERROR(INDEX($E$7:$E$22,MATCH(I7,$F$7:$F$22,0)),"")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.
1 Reply
=IFERROR(INDEX($E$7:$E$22,MATCH(I7,$F$7:$F$22,0)),"")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.