Oct 25 2022 03:40 AM
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
Oct 25 2022 03:54 AM
Solution=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.
Oct 25 2022 03:54 AM
Solution=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.