View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default Multiple criteria

Hi, i have a complex database sheet, but a simple example will show you what
i need:
database sheet
A B C
John 12.05.2008 12
Mary 01.02.2009 14
John 04.04.2009 9
Mary 27.02.2009 4

result sheet
A B C
John 12.05.2009 12
Mary 27.02.2009 4

I need a code that return datas from "C" if "A" and "C" match.
Something like:
=if(A<,B<,return C), or something with match, vlookup....etc, i don't know.

Can this be done?
Thanks!