Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel - Using IF Function
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel - Using IF Function
Resolved · High Priority · Version 2007
Reply Thu 20 May 2010, 22:01Delegate 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.
For upcoming training course dates see: Pricing & availability
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.
|