|
Sorting and Finding data
Anyone know a macro or formula that could do the following: IF A and B on Sheet1 match A and B on Sheet2 THEN C on sheet2 will be moved to C on sheet1 Any ideas? Many Thanks Sam -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=545617 |
Sorting and Finding data
Sam,
Try the following formula: =IF(AND(A1=Sheet2!A1,B1=Sheet2!B1),Sheet2!C1,"") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "SamGB" wrote in message ... Anyone know a macro or formula that could do the following: IF A and B on Sheet1 match A and B on Sheet2 THEN C on sheet2 will be moved to C on sheet1 Any ideas? Many Thanks Sam -- SamGB ------------------------------------------------------------------------ SamGB's Profile: http://www.excelforum.com/member.php...o&userid=31263 View this thread: http://www.excelforum.com/showthread...hreadid=545617 |
| All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com