The VLOOKUP Thread

[kranepool]

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)

[A_B]

Put a comma after the FALSE

[kranepool]

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.

[wlu_lax6]

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]

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.

[Johnny Hotcakes]

Hmm, have you tried just =VLOOKUP(L2,$B$2:$I$13,1) ?

That should work, shouldn't it?

[Johnny Hotcakes]

Also, I don't think you need false at the end.

[Scottie]

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.

[kranepool]

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.

[kranepool]

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".

[A_B]

I don't see why you don't slot Harper in LF and go from there, all else be damned.

[kranepool]

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.

[Ryan]

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.

[kranepool]

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!

[kranepool]

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!

[Square Rob]

Yeah, with vlookup the sought after field must be to the right of the lookup/match field.

[Ryan]

Good vlookin' out!

You're welcome, and that was very clever