Indeed it should sir. Thanks.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Toppers" wrote in message
...
Bob, should it be ....?

=VLOOKUP($O$1,$A$1:$N$13,ROW(A2),FALSE)

"Bob Phillips" wrote:

Sure, just use

=VLOOKUP(O1,$A$2:$A$13,ROW(A2),FALSE)

where O1 is the dropdown, and just copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"frizzocki"
wrote in
message ...

I'm working on a fantasy football spreadsheet and I want to use a drop
down menu to do side by side matchup comparisons.
A2:A13 I have the team names, and from Columns B to N are their
respective stats.
Is it possible to have a drop down menu, and based on which team I
select, it show stats from B,C,D,E...N below it?

I've only gotten as far as creating a drop down menu. Is there a
lookup function specific to this type of situation? Any help would
greatly be appreciated.


--
frizzocki

------------------------------------------------------------------------
frizzocki's Profile:
http://www.excelforum.com/member.php...o&userid=37830
View this thread:
http://www.excelforum.com/showthread...hreadid=573841