All Hokie, All the Time. Period. Presented by First Bank & Trust Company

H
Hurley09 OP
Feb 03, 2025 at 07:16 PM ET
Any excel XLookup gurus out there? Need help with a formula
I am terrible at Excel and I tried looking this up but the Microsoft Support page may as well have been written in swahili cause I couldn't follow that at all. I have an excel file with two tabs. Tab 1 and Tab 2. My goal: Compare Column A in Tab 1 and Column A in Tab 2. If there is a match return "True" in Column H of Tab 1. Thanks all.

11 Replies

H
hokiehunter07
copy and paste your question into Chat GBT
Or Copilot or Gemini. My new go to for Excel questions.
VTJayLaw VTJayLaw
Are you looking for the value in tab 1 column A to exist anywhere
In tab b column a? Or if tab 1 a1 = tab 2 a1? If the former you can use a vlookup. If the later MP4VT2004 has it I think.
MP4VT2004 MP4VT2004
Edit: see below
** Edited by MP4VT2004 at 2/3/2025, 8:58:18 PM
MAHokie69 MAHokie69
YouTube has everything
Sounds like a VLookup function to me
H
Happy Dog
YouTube rules
I was teaching an online class that involved linear programming. Textbook was ok, but I found a few YouTube videos that explained much better.
E
EDGEMAN
So many great videos there. My favorites are the auto maintenance ones
I have always recommend that anyone who doesn't do car maintenance to watch what's involved before just taking their vehicle to a repair shop or agreeing to pay outrageous prices for something they can easily do themselves. For example, I think buying a cabin air filter from Amazon for $20 and spending 5 minutes to replacing it yourself is much better than paying a shop $100 to do it. If you want factory parts, then do a web search for "OEM" parts. There are a lot of dealers who sell parts online at discounted prices. Auto maintenance isn't expensive if you do most of the routine stuff yourself. If it's beyond your capability, then by all means have a shop perform the maintenance.
H
Happy Dog
Carburetor maintenance, learn to play bass, replace fridge light switch....
just a few things recently I have learned on YouTube. There's also a lot of time-wasting on YouTube. I try to avoid that. \ Oh, and TSL podcasts!
E
EDGEMAN
You can definitely go down the rabbit hole on things...
...I got on a lot of go-cart and minibike videos during the pandemic. Modifying engines, drives, etc. to go faster...lol
MP4VT2004 MP4VT2004
Are you comparing like row for like row?
MP4VT2004 MP4VT2004
If so, see inside for possible solution:
=If("TabA"A:1="TabB"A:1,"True","False")
D
DallasHokie98
use match() function but Excel is finicky about alphanumeric order
I don't recall if that is true with the match() function. Also use match_type = 0.