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