• 503K Members
• 7,884 Online
• 601K Conversations

Contributor

# 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.
8 Replies

# Re: Checking A Column

Perhaps

`=IFERROR(INDEX(\$A\$2:\$A\$4, MATCH(B1,\$B\$2:\$B\$4,0)),"no such")`

# Re: Checking A Column

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)

# Re: Checking A Column

It could be

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

# Re: Checking A Column

I attached the file. For some reason it still returns False even though A1 & B1 should both be true

# Re: Checking A Column

I attached the file. For some reason it still returns False even though A1 & B1 should both be true

# Re: Checking A Column

That's since you have "Doreen" in A1 and "Doreen " in A3. As variant it could be

`=IFERROR(INDEX(TRIM(\$A\$2:\$A\$4), MATCH(B1&"*",B2:B4,0))=TRIM(A1),"TRUE")`

# Re: Checking A Column

Two things
1) OMG THANK YOU. YOU HAVE NO IDEA HOW MUCH MY HEAD HURT TRYING TO FIGURE IT OUT
2) I can't belive the problem was an invisible space. Excel is SENSITIVE

# Re: Checking A Column

You are welcome. Yes, that could be not only spaces but other invisible characters, e.g. if you copy/paste from web. In most cases TRIM() and CLEAN() could help.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies