Forum Discussion
If then formula help
Without knowing about the layout of your sheets and data its hard to suggest a pin point solution but to give you an idea, you may try something like this and tweak it as per your requirement.
Assuming you have a Sheet called List with Emp# and EmpName, try this on Data sheet...
In R2
=IFERROR(INDEX(List!A:A,MATCH(H2,List!B:B,0)),"")
Thank you, let me be more specific I did not specify properly.
Colum "H" has about 800 rows, but only about 20 different names of employees that repeat often, some more than others.
Colum "R" has nothing.
I want to add a formula to colum R
For example, if "H4" has "JOHN" then "R4" has "2525",
if "H5" has "MARY" then "R5" should have "5151"
So, If I add a new value, in "H891" that is "JOHN" then automatically "R891" Should fill up with "2525"
Hope that explains it better, thank you for the help.
ocasiomd wrote:Thank you, let me be more specific I did not specify properly.
Colum "H" has about 800 rows, but only about 20 different names of employees that repeat often, some more than others.
Colum "R" has nothing.
I want to add a formula to colum R
For example, if "H4" has "JOHN" then "R4" has "2525",
if "H5" has "MARY" then "R5" should have "5151"
So, If I add a new value, in "H891" that is "JOHN" then automatically "R891" Should fill up with "2525"
Hope that explains it better, thank you for the help.
That's not how you should do this. You must be referring to a list somewhere in the file to know what Emp# is to be populated in column R based on EmpName in column H.
Having 20 nested IFs in the formula doesn't make any sense.
Why not upload a truncated version of your file after removing any sensitive info in it so that we can figure out a better way to accomplish what you are trying to achieve?