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