Hi!
Maybe something like this:
=IF(AND($A1=SHEET2!$A1,$B1=SHEET2!$B1),SHEET2!C1," ")
Copy across as needed.
If this isn't even remotely close to what you want,
perhaps you should post some sample data (in great detail)
along with the results that you are expecting.
Biff
-----Original Message-----
I have 5 columns on two worksheets, same book, idential
columns. I want
columns c, d, and e to populate from the 2nd sheet if
columns a & b are the
same on both. I need the combination of column a to
column b to match (items
are doubled in column a; last three columns are
determined then by b).
I tried VLOOKUP (using A2:B2 as the lookup) but that
didn't work. I've
tried different IF and AND formulas, and just can't seem
to get it right.
Can someone help please?!?!
.
|