asked

I am having issues with a VLOOKUP formula in a benefits report where I am comparing data sets A and B using the identifier EE Number from Set A to pull in various data from Set B. Each employee is listed multiple times with different benefits and amounts. The formula is only providing the first two results and then duplicating the rest. How can I fix the formula to correctly pull different benefit codes for each employee?

April 25th, 2023

Sign Up to View Answers

Create an account to view answers and interact with the community!