Multiple criteria

P

puiuluipui

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!
 
E

Eduardo

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 ??
 
P

puiuluipui

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:
 
E

Eduardo

Hi,
I assume that you are entering the information in another worksheet and you
need the id to be pulled from the original sheet (sheet1)

so in column C sheet 2 enter

=sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100)

I assumed that your range is from 1 to 100 change it to fit your needs

If this was helpful please click yes, thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top