I am trying to create a timecard that auto fills cells based on a table of job numbers, cost codes, phases, and job names.
I am using the VLOOKUP function and it is giving me a #NO MATCH.
=IF([Job Number]@row = 120403, VLOOKUP([Cost Code]@row, [Job Number]33:[Phase (Area)]45, 3, false), VLOOKUP([Job Number]@row, [Job Number]33:[Phase (Area)]45, 3, false))
Ideally, when someone chooses a job number and cost code the job name and phase would populate.. making for less data entry and less errors.
What am I doing wrong? Is there a better way to accomplish what I am trying to do?
Please help. Thanks!
Help Article Resources
Check out the Formula Handbook template!