Forum Discussion
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 are
So if my formula above= True because of B3 then A1 must equal A3 for it to return the true value. How should I continue the formula. I did try Vlookup but I couldnt figure out how to phrase it in a conditional way.
=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 are
So if my formula above= True because of B3 then A1 must equal A3 for it to return the true value. How should I continue the formula. I did try Vlookup but I couldnt figure out how to phrase it in a conditional way.
8 Replies
- 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)
