Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 27

Choose and Match

Hi All,

Site TV MP3 Cell Phone

NY Margin ($) $338,101 $292,277 $377,098
Margin (%) 34% 29% 41%

NJ Margin ($) $282,301 $261,081 $243,448
Margin (%) 28% 26% 26%

i have above data, i want for example if user choose NY and TV from their
drop down list $ 338,101 and 34% appear in respective cells

any suggestion

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
choose+match!!	pierre	Excel Discussion (Misc queries)	1	April 18th 08 07:32 PM
choose+match	pierre	Excel Discussion (Misc queries)	4	April 17th 08 10:04 PM
choose match formula	Scott@CW	Excel Discussion (Misc queries)	2	September 5th 07 08:58 PM
Help with lookups (Index/Offset/Match/Choose???)	[email protected]	Excel Discussion (Misc queries)	3	August 15th 07 09:31 PM
VLOOKUP, INDEX, MATCH... What to choose	Piloulondon	Excel Worksheet Functions	3	August 20th 05 07:15 PM

All times are GMT +1. The time now is 06:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us