| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding last used | Excel Worksheet Functions | |||
| Sorting Referenced Cells | Links and Linking in Excel | |||
| sorting data by a certain attribute | Excel Worksheet Functions | |||
| Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
| Finding the maxium value of a column | Excel Worksheet Functions | |||
Linear Mode
