Are you looking for the value in tab 1 column A to exist anywhere

All Hokie, All the Time. Period. Presented by

The Lounge

Post #1232705 ◀ PREV NEXT ▶

Joined: 09/13/2002

Posts: 3,396

Likes: 1,592

VTJayLaw

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.

Posted: 02/03/2025 at 11:22 PM ET

(In response to this post by Hurley09)

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

Edit: see below -- MP4VT2004 Feb 03, 2025 at 08:57 PM ET

MP4VT2004 • 02/03/25 08:57 PM ET

YouTube has everything -- MAHokie69 Feb 03, 2025 at 08:12 PM ET

MAHokie69 • 02/03/25 08:12 PM ET

YouTube rules -- Happy Dog Feb 04, 2025 at 05:20 AM ET

Happy Dog • 02/04/25 05:20 AM 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