Multiple criteria
Hi, i have many of John entry with diferent data in column B, and an id in C
column.
In result database, i will write in A, John, in B i will write a date and in
C, i need the id that i have entered in that day for John. If i need another
id from another day, i will change the data in column B. The same for Mary.
Thanks!
"Eduardo" a scris:
Hi,
could you please be more specific, I see John twice in column A with
different data in column B and C and you bring only the first line ??
"puiuluipui" wrote:
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!
|