Ask ChatGPT to explain it to you - seriously.

It involves using a formula called VLOOKUP that looks up data in a column. You can highlight a cell if it is repeated or missing out of a list. But VLOOKUP is the easiest method, IMO.

4 ...

Report Post

Posted by dtett

Jiggacity

Member since Oct 2018

520 posts

Posted on 4/25/24 at 12:48 pm to FortunateSon

Its unfair how well it does at writing macros and formulas to do exactly what you tell it to. I only discovered it this week. Beats the hell out of googling for a specific solution and piecing a macro together like I used to.

0 ...

Report Post

Posted by Loubacca

sittin on the dock of the bay

Member since Feb 2005

4024 posts

Posted on 4/25/24 at 1:42 pm to FortunateSon

Yes, VLOOKUP is what you are looking for. I use that function daily.

0 ...

Report Post

Posted by mdomingue

Lafayette, LA

Member since Nov 2010

30591 posts

Posted on 4/25/24 at 2:26 pm to FortunateSon

I prefer Xlookup generally

1 ...

Report Post

Posted by captainpodnuh

Baton Rouge, LA

Member since Jan 2004

479 posts

Posted on 4/26/24 at 2:59 pm to FortunateSon

quote:
Ask ChatGPT to explain it to you - seriously. It involves using a formula called VLOOKUP that looks up data in a column. You can highlight a cell if it is repeated or missing out of a list. But VLOOKUP is the easiest method, IMO.

This 100%. Depending on what dataset you have, I also have had success with INDEX and MATCH. Thanks to ChatGPT. If you tell it your column numbers and worksheet tab names. it will completely write the formula for you. Copy and paste. Done.

0 ...

Report Post

Tech Board - Replies to Post

Return To Board

Page 1

Return To Board