98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel- if and match
Excel- if and match
Resolved · Medium Priority · Version 2013
Thu 5 Apr 2018, 12:43Delegate Suellen said...
Suellen has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Pivot Tables course
Excel- if and match
Hello!
I am trying to use two formulas together, in order to match one table with another; however, I am not getting the right combination.
Could someone help me with it.
example:
Column 1 I have programs names & Column 2 I have Coverages
What I need is for excel to tell me the code (which is in another table) of the programs.
I tried to use the formula =IF(G24="JN",290407,FALSE), which worked however I need to add another 20 codes.
Thank you
Suellen
Thu 5 Apr 2018, 13:59Trainer Sarah said...
RE: Excel- if and match
Hi Suellen
If Table2 has a coloumn of programs as well as the corresponding codes, you should be able to use an INDEX MATCH function to do this:
=Index(Table2_CodeRange,MATCH(Table1_LookupProgram,Table2_ProgramRange,0))
If this isn't possible, you could use a nested IF to add your other codes:
=IF(G24="JN",290407,IF(G24="program","code",IF(G24="program","code",IF(... etc etc
However, the nested IF method is much longer and harder to avoid errors.
Hope this answers your question, let us know if you need any more help!
Regards
Sarah
Excel Trainer
Thu 12 Apr 2018: Automatically marked as resolved.
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 tip:Creating charts in Excel 2010Here's how to present your data in a chart format: |
