Okay . . . let's try this again.
Moderators: Shirley , Sabo , brian , rass , DaveInSeattle
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Sat Apr 06, 2013 1:33 pm
I'm doin' it wrong.
While scrimmaging pre-opening day, I am setting lineups and evaluating new players at the plate and in the field.
In an effort to I'm looking for a way to auto-populate Cell M2 with L2's position for the inning.
For me, I want to know
who I have
where , so the table on the left makes the most sense.
For players, they want to know
when they're up, and
where they are in the field.
Yet, I cannot make Kit's name show up in M2 without double-keying "Kit".
Lil help?
(NO PEPPER)
mini puke to 1,558
A_B
The Dude
Posts: 23591 Joined: Mon Mar 11, 2013 7:36 am
Location: Getting them boards like a wolf in the chicken pen.
Post
by A_B » Sun Apr 07, 2013 10:40 am
Put a comma after the FALSE
Hold on, I'm trying to see if Jack London ever gets this fire built or not.
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Sun Apr 07, 2013 11:52 am
Thanks, AB_S_T, but I get a "you've entered too many arguments for this function " message.
I say, "no I haven't", but my computer doesn't appreciate Monty Python.
mini puke to 1,558
wlu_lax6
The Dude
Posts: 10574 Joined: Tue Mar 12, 2013 7:16 am
Post
by wlu_lax6 » Sun Apr 07, 2013 7:42 pm
Is your 2nd argument right? "B:I". Don't you need that to be B2:B13 or something like that? The other common vlookup problem is a space character hidden. I frequently have to use "trim()" in formulas when pulling in external data to make sure I get rid of the leading and trailing spaces.
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Sun Apr 07, 2013 9:02 pm
I've double and triple checked.
I've tried B2:I13.
I've tried $B$2:$I$13.
I've tried removing all spaces [CTRL+H] (there are none leading/trailing).
I've tried tables for each data set.
I've cut and pasted-values into a new sheet.
Smashing my skull on the desk here. Double-keying makes me nuts.
mini puke to 1,558
Johnny Hotcakes
Brandt
Posts: 377 Joined: Mon Mar 11, 2013 12:04 pm
Post
by Johnny Hotcakes » Sun Apr 07, 2013 11:48 pm
Hmm, have you tried just =VLOOKUP(L2,$B$2:$I$13,1) ?
That should work, shouldn't it?
Popin' ain't easy
Scottie
Donny
Posts: 2303 Joined: Mon Mar 11, 2013 1:52 am
Location: Warming up in the bullpen.
Post
by Scottie » Mon Apr 08, 2013 12:44 am
So . . . I'm the only Swamper that thought, instinctively, that this was an up-skirt beaver shoot photo posting thread?
Yeah yeah yeah yeah yeah yeah yeah. Ah, well.
Your own personal AR-15 wielding Jesus
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Mon Apr 08, 2013 6:11 am
Johnny Hotcakes wrote: Hmm, have you tried just =VLOOKUP(L2,$B$2:$I$13,1) ?
That should work, shouldn't it?
OK. Shit just got weird.
Removing "FALSE" or "0" at the end of the argument insinuates "TRUE" or "1", which is fuzzy match. FALSE/0 yields exact match.
Not sure why I'm getting
something now instead of errors.
mini puke to 1,558
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Mon Apr 08, 2013 6:14 am
Scottie wrote: So . . . I'm the only Swamper that thought, instinctively, that this was an up-skirt beaver shoot photo posting thread?
I'd probably put that in the "Temporary Pope Resigned, Now A New Temporary Pope Thread" thread.
Or "Poles and Polls".
mini puke to 1,558
A_B
The Dude
Posts: 23591 Joined: Mon Mar 11, 2013 7:36 am
Location: Getting them boards like a wolf in the chicken pen.
Post
by A_B » Mon Apr 08, 2013 7:21 am
I don't see why you don't slot Harper in LF and go from there, all else be damned.
Hold on, I'm trying to see if Jack London ever gets this fire built or not.
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Mon Apr 08, 2013 7:47 am
Needy little bastard wants to pitch.
"You should just call me Bryce Harper, that's what everybody calls me anyway."
You'll bat last and like it.
mini puke to 1,558
Ryan
The Dude
Posts: 10546 Joined: Mon Mar 18, 2013 10:01 am
Post
by Ryan » Mon Apr 08, 2013 8:00 am
Doesn't the column where the names you're trying to match have to be the first column of the lookup table?
It works if you do this:
you just have to point the lookup to a new array for each inning. There's probably a better way, though.
he’s a fixbking cyborg or some shit. The
holy fuckbAllZ, what a ducking nightmare. Holy shot. Just, fuck. The
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Mon Apr 08, 2013 8:34 am
Ryan wrote: Doesn't the column where the names you're trying to match have to be the first column of the lookup table?
I thought that since I was trying to return position, that position in the first table needed to be on the left, but I think you're right.
I'll give that a shot and report back, thanks!
mini puke to 1,558
kranepool
Bunny Lebowski
Posts: 575 Joined: Tue Mar 19, 2013 8:46 am
Post
by kranepool » Mon Apr 08, 2013 8:44 am
Since this was more important than work, I just tried it. It shakes out.
What I did was moved the "position" column to the right, as you suggested, and then I copy-and-pasted the "position" column in-between each inning.
I'll hide the additional position columns, and it will look exactly the same.
Thanks!
mini puke to 1,558
Square Rob
Jesus Quintana
Posts: 769 Joined: Thu Mar 14, 2013 3:43 pm
Post
by Square Rob » Mon Apr 08, 2013 8:58 am
Yeah, with vlookup the sought after field must be to the right of the lookup/match field.
Ryan
The Dude
Posts: 10546 Joined: Mon Mar 18, 2013 10:01 am
Post
by Ryan » Mon Apr 08, 2013 9:06 am
kranepool wrote: Good vlookin' out!
You're welcome, and that was very clever
he’s a fixbking cyborg or some shit. The
holy fuckbAllZ, what a ducking nightmare. Holy shot. Just, fuck. The