View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atif Atif is offline
external usenet poster
 
Posts: 27
Default 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