Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Using IF Function

Excel - Using IF Function

ResolvedVersion 2007

Thu 20 May 2010, 22:01 Delegate Jankhana said...

Jankhana has attended:
Excel Introduction course
Excel Intermediate course
Excel Intermediate course
Excel Advanced course

Excel - Using IF Function

In a work book I have monthly sheet and 1 consolidated sheet and need to extract data from Monthly sheet into Consolidated. Every monthly work sheet has Unique Data (Account No) in Column A & B.

What formula should I use if Criteria is - Both the column of the two worksheet i.e A & B sholud be considered for extracting amount from secondary sheet.

Mon 24 May 2010, 10:00 Trainer Simon said...

RE: Excel - Using IF Function

Hi Jankhana,

Thank you for your question and welcome to the forum.

It sounds like you need a nested if function or a nested vlookup.

Please find the following links below that will help you understand how to construct them:

http://spreadsheets.about.com/od/tipsandfaqs/qt/nested_if.htm

http://office.microsoft.com/en-us/excel/hp052093351033.aspx

I hope this helps.

Regards

Simon

Sun 30 May 2010: Automatically marked as resolved.

Excel tip:

Missing Field handle

If your field handle goes missing all you need to do is go to tools > options > edit tab and then make sure that the check boxes for paste and insert buttons are checked.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel - Using IF Function

Excel - Using IF Function

RE: Excel - Using IF Function

Excel articles

Excel tip:

Missing Field handle