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
1y
Or Copilot or Gemini. My new go to for Excel questions.
(In response to this post by Hurley09)
1y
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.
(In response to this post by Hurley09)
1y
** Edited by MP4VT2004 at 2/3/2025, 8:58:18 PM
(In response to this post by Hurley09)
1y
Sounds like a VLookup function to me
Link:
Click me!
(In response to this post by Hurley09)
1y
I was teaching an online class that involved linear programming. Textbook was ok, but I found a few YouTube videos that explained much better.
(In response to this post by MAHokie69)
E
EDGEMAN
1y
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.
(In response to this post by Happy Dog)
1y
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!
(In response to this post by EDGEMAN)
E
EDGEMAN
1y
...I got on a lot of go-cart and minibike videos during the pandemic. Modifying engines, drives, etc. to go faster...lol
(In response to this post by Happy Dog)
1y
=If("TabA"A:1="TabB"A:1,"True","False")
(In response to this post by MP4VT2004)
1y
I don't recall if that is true with the match() function. Also use match_type = 0.
Link:
https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a
(In response to this post by Hurley09)