Posted to microsoft.public.excel.misc
|
|
Drop down menu with results
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
|