mustish1
asked on
Error in VLookup
I am trying to create a summary report in sheet2. When i enter the employee code it automatically fill the rest of the values from sheet1. But getting error in vlookup. Need help
SmryRpt.xlsx
SmryRpt.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The $ sign is making the G2 as an absolute reference. But as per your existing layout you can remove the $ sign from G2.
ASKER