Compare names and return win or loss

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
blablok
Posts: 72
Joined: Tue May 24, 2022 12:14 pm

Hi,

Im kinda stuck with this.
Id like to check if dog in COL E is available on the list in COl I and if SO then return value from COL F (whether 0 or 1)
I tried this:
=INDEX(F2:F809,MATCH(E2,I$2:I$232))
but dont ask :)
Thanks in advance.
You do not have the required permissions to view the files attached to this post.
Anbell
Posts: 2004
Joined: Fri Apr 05, 2019 2:31 am

blablok wrote:
Tue Jun 28, 2022 2:07 pm
Hi,

Im kinda stuck with this.
Id like to check if dog in COL E is available on the list in COl I and if SO then return value from COL F (whether 0 or 1)
I tried this:
=INDEX(F2:F809,MATCH(E2,I$2:I$232))
but dont ask :)
Thanks in advance.
Use xlookup
User avatar
Trader724
Posts: 559
Joined: Fri Dec 27, 2019 11:22 pm

=IF(ISNUMBER(MATCH(E2, I:I, 0)),F2, "not on the list")
User avatar
blablok
Posts: 72
Joined: Tue May 24, 2022 12:14 pm

Trader724 wrote:
Wed Jun 29, 2022 7:38 am
=IF(ISNUMBER(MATCH(E2, I:I, 0)),F2, "not on the list")
Fantastic ! Thank you !
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”