Google Spreadsheet-Return exact match

**KentaTippar** · 09-18-2021, 09:43 AM

I have 1 match
i want the right number to return, if i place a bet like in (my bettings)number 1, it return 1 if 1 is correct, 2 if X is correct and 3 if 2 is correct.
Is it possible with a formula so it can return the exact match ( not 1,2 or 3), i want 1, X or 2

my bettings
1.1X2

correct row
1.2

from another sheet i use this formula to compare with my "bettings"
=IFERROR(SEARCH('Stryktipset 2021'!B9;F6);" ")
B9 is the correct row and F6 is my bettings

Sorry for my english, its not always easy to understand

**AliGW** · 09-18-2021, 09:50 AM

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/for-other...-in-a-row.html