View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Popups to look up on two variable columns


Send file with explanation to dguillett1 @gmail.com Should be easy enough.

On Thursday, March 15, 2012 11:33:48 AM UTC-5, Colin Hayes wrote:





Then a popup would request the choice of a second column , and ask for
specific content.

It would select all rows below the number input in the first popup which
matched the content entered in the second.


For example ;

The first popup(s) input specifies all cells numbered below 100 in
column B.

The second popup(s) would specify a certain content - Say 'Blue' - in
column F.


Result :

1 Green - Not Selected
2 Blue - Selected
23 Blue - Selected
44 Yellow - Not Selected
56 Blue - Selected
78 Red - Not Selected
102 Blue - Not Selected
203 Blue - Not Selected
205 Green - Not Selected
204 Yellow - Not Selected


Grateful for any advice.