Need Help in Excel
Closed
Mani
-
Jun 7, 2009 at 03:44 PM
mubashir aziz
mubashir aziz
- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010
Related:
- Need Help in Excel
- Transfer data from one excel worksheet to another automatically - Guide
- How to change date format in excel - Guide
- Excel @ in formula ✓ - Forum - Excel
- How to change author name in excel - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Forum - Excel
1 reply
mubashir aziz
Jun 7, 2009 at 11:54 PM
- Posts
- 190
- Registration date
- Sunday April 12, 2009
- Status
- Member
- Last seen
- February 16, 2010
Jun 7, 2009 at 11:54 PM
Suppose you have data in Column A in Sheet 1 & Sheet 2 then use this formula in Sheet3 Cell A1 and drag it down .... ........
=IF(ISERROR(VLOOKUP(Sheet1!A1,Sheet2!A:A,1,FALSE)),Sheet1!A1,"")
=IF(ISERROR(VLOOKUP(Sheet1!A1,Sheet2!A:A,1,FALSE)),Sheet1!A1,"")