Hi Phillip,
Ok I am assuming that you have sheet1 and sheet 2 columns A & B with the
information to be matched and you want the results from Sheet 2 column C
total rows assumed from 1 to 30000 change to fit your needs

=sumproduct(--(a1=sheet2!$a$1:$a$30000),--(b1=sheet2!$B$1:$b$30000),sheet2!$c$1:$c$30000)

If this was helpful please click yes. thank you

"phillip warren" wrote:

I need a formula that will allow me to match 2 cells from 2 different
columns on one sheet to two columns on another sheet. Then if they match I
need the data from another column (same row) to be put in on the 1st sheet.

If anyone can help I would be most appreciative as I am pulling my hair out
here !

I can email any more info as is necessary, as I would imagine that you will
need the sheet to look at with a better explanation!

Thanks guys

url:http://www.ureader.com/gp/1042-1.aspx