Need Help in Excel [Closed]

Question

Need Help in Excel [Closed]

Report

Mani - Jun 7, 2009 at 03:44 PM
mubashir aziz

Posts: 191
Registration date: Sunday April 12, 2009
Status: Member
Last seen: February 16, 2010

- Jun 7, 2009 at 11:54 PM

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 ???

Need Help in Excel
How to change date format in excel to dd/mm/yyyy - How-To - Excel
Formula bar not showing in excel - How-To - Excel
File path in excel - How-To - Excel
Spell number in excel download - Forum - Excel
How to change author in excel - How-To - Excel

1 reply

Ask a question

mubashir aziz · Answer 1 · 2009-06-07T23:54:28-0400

Answer 1 / 1

mubashir aziz

Posts: 191
Registration date: Sunday April 12, 2009
Status: Member
Last seen: February 16, 2010

215
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,"")

Need Help in Excel [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!