The formula used (adapted to my specific sheets) is:
=INDEX('12 All'!C2:C20,MATCH(A2&B2,'12 All'!A2:A20&'12 All'!B2:B20,0))
My 2nd sheet (containing the values to populate from) is 12 All. The 1st
sheet (needs to be populated) is 10 All. I clicked on the sheets instead of
typing in. This formula returned #VALUE. Both sheets are sorted in
ascending order; column A has numbers, B has text, C, D, and E will all be
numbers.
Any additional help would be appreciated!
Thanks,
Darcie
"Peo Sjoblom" wrote:
Try
=INDEX(Sheet2!C2:C20,MATCH(A4&B4,Sheet2!A2:A20&She et2!B2:B20,0))
entered with ctrl + shift & enter
where you would return values from C2:C20 where A4&B4 match in A2:B20
Regards,
Peo Sjoblom
"o1darcie1o" wrote:
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?!?!
|