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

Don't email... just post more description. For example, what 2 cells from
what 2 columns on which sheet (give us rows, columns and sheet name)? When
you say 2 columns on another sheet, what do you mean... are you trying to
see if the one of the cells is located within a range in one column and the
other cell is located within a range in the second column? If so, what
columns go with what cells (and what is the sheet name containing these 2
columns)? Is the look up an "and" (both cells must be found in their
respective columns) or an "or" (at least one of the cells must be found, but
not necessarily both cells)? Remember, you know what you are doing while we
have no idea... so you have to tell us in your description of the problem.

--
Rick (MVP - Excel)


"phillip warren" wrote in message
.. .
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

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