View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to search a value with two criteria from a database?

Search for the least likely value. Then for each one found, check for the
second value in the same row.

See help for the FindNext command in Excel VBA help to see an example.
Specify values for all arguments for the find method in your command (unlike
the example) to ensure consistent behavior.

--
Regards,
Tom Ogilvy

"alex lee" <alex wrote in message
...