Menu
  1. Accueil
  2. Forum
  3. Office Software
  4. Excel

Need Help in Excel [Closed]

Report
-
mubashir aziz
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 -
Hello,

I have two excel sheets with around 8000 columns in one sheets and 2000 columns in second sheet. All the columns of second sheets are taken from the first sheet. I have to create third excel sheet which should have missing numbers of second sheets.
Is there any formulae to do this fastly ???
See more

1 reply

Answer 1 / 1
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 210
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,"")


Ask a question