H
Joined:
01/01/2005
Posts:
9,615
Likes:
4,467
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.
Posted: 02/03/2025 at 07:16 PM ET
Thread Replies (11)
Any excel XLookup gurus out there? Need help with a formula
◄
-- Hurley09
Feb 03, 2025 at 07:16 PM ET
Hurley09
•
02/03/25 07:16 PM ET
copy and paste your question into Chat GBT
-- hokiehunter07
Feb 04, 2025 at 03:48 PM ET
hokiehunter07
•
02/04/25 03:48 PM ET
Are you looking for the value in tab 1 column A to exist anywhere
-- VTJayLaw
Feb 03, 2025 at 11:22 PM ET
VTJayLaw
•
02/03/25 11:22 PM ET
So many great videos there. My favorites are the auto maintenance ones
-- EDGEMAN
Feb 04, 2025 at 06:57 AM ET
EDGEMAN
•
02/04/25 06:57 AM ET
Carburetor maintenance, learn to play bass, replace fridge light switch....
-- Happy Dog
Feb 04, 2025 at 07:43 AM ET
Happy Dog
•
02/04/25 07:43 AM ET
You can definitely go down the rabbit hole on things...
-- EDGEMAN
Feb 04, 2025 at 09:35 AM ET
EDGEMAN
•
02/04/25 09:35 AM ET
Are you comparing like row for like row?**
-- MP4VT2004
Feb 03, 2025 at 08:08 PM ET
MP4VT2004
•
02/03/25 08:08 PM ET
If so, see inside for possible solution:
-- MP4VT2004
Feb 03, 2025 at 08:57 PM ET
MP4VT2004
•
02/03/25 08:57 PM ET
use match() function but Excel is finicky about alphanumeric order
-- DallasHokie98
Feb 03, 2025 at 07:21 PM ET
DallasHokie98
•
02/03/25 07:21 PM ET