ST Alpha - "My BIL (i guess that's the right term?) has an excel question for y'all. Vlookup related. I'm going to add an account for him so he can ask here. -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 158

My BIL (i guess that's the right term?) has an excel question for y'all. Vlookup related. I'm going to add an account for him so he can ask here. -- nm

Posted by Beryllium (aka grayman) Aug 11 '23, 10:07

(No message)

Responses:

Looks like this is his question, but the sticking point is in the follow-up comment about column D. -- (link) - Beryllium Aug 11, 10:32 7
- Not sure I completely understand what he's asking. Is it as simple as... - Dano Aug 11, 10:45
- Josh is very confusing :) - oblique Aug 11, 10:42 3
  - I'm a bit unclear on it myself. It seems like maybe he's trying to make an auto-pairing sheet for mock trials or something. -- nm* - Beryllium Aug 11, 10:47 2
    - conflicts list - sweatshopking Aug 11, 11:26
    - My guess would be he's messing up the second parameter (search range) and not having the first column contain what he is searching for -- (edited) - oblique Aug 11, 10:53
- hmm, I wonder if columnar formatting still works on ST -- (edited) - Beryllium Aug 11, 10:38 1
  - and you're only telling us NOW?!? - decline Aug 11, 10:41
"use xlookup instead." next question? -- nm - 🏳️‍🌈 judge jones 🏳️‍🌈 Aug 11, 10:22 1
- Doesn't work if you don't have the latest version of Excel. -- nm - spamlet Aug 11, 10:54
I just used a VLOOKUP. I'm ready :) -- nm - oblique Aug 11, 10:15
*slides a bar of soap in a long sock* - Will Hunting Aug 11, 10:09

Post a message top

Replies are disabled on threads older than 7 days.