Forum Discussion

Thomas Bryant's avatar
Thomas Bryant
Copper Contributor
Jun 20, 2019

Checking A Column

So I've made the following formula =IF(MATCH(B1,B2:B4,0),"True") What I want to do is if it returns true I want it to compare the corresponding A column cell to A1 and only return True if they both ...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 20, 2019

Thomas Bryant 

Perhaps

=IFERROR(INDEX($A$2:$A$4, MATCH(B1,$B$2:$B$4,0)),"no such")
  • Thomas Bryant's avatar
    Thomas Bryant
    Copper Contributor
    Jun 20, 2019
    It was a help. That formula returns the respective cell value. Now to fugure out how to get it to return False if the value isn't equal to A1. Heres an edit I just tried that didn't work
    =If((IFERROR(INDEX($A$2:$A$4, MATCH(B1,$B$2:$B$4,0))=A1,True,False)
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 20, 2019

      Thomas Bryant 

       

      It could be

      =IFERROR(INDEX($A$2:$A$4, MATCH(B1,B2:B4,0))=A1,FALSE)

Resources