Using if function and vlookup
I would like to populate sheet the first sheet shown below which is entitled "Process Step Capture Tool" with data from the second sheet below entitled"Test Sheet" and I think I need to use the if and vlookup functions. What I am trying to do in the top sheet is say if the Process # is Process 1 then add the corresponding Process Name from the bottom sheet.
I hope that makes sense. Any help would be much appreciated.
Help Article Resources
Check out the Formula Handbook template!