Need Help in Excel
Closed
Mani
-
Jun 7, 2009 at 03:44 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 7, 2009 at 11:54 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jun 7, 2009 at 11:54 PM
Related:
- Need Help in Excel
- Excel date format dd.mm.yyyy - Guide
- Screenshot in excel - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Macros in excel download - Download - Spreadsheets
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
Jun 7, 2009 at 11:54 PM
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,"")