SOLVED

Match two values and return ticker

Copper 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 (Copper Contributor)
Solution

@packie 

=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.

index match.JPG

1 best response

Accepted Solutions
best response confirmed by packie (Copper Contributor)
Solution

@packie 

=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.

index match.JPG

View solution in original post