I have am working within a workbook.
On sheet named DATA column A I have listed each of the health benefit plans offered. In column B I have listed the corresponding weekly employee cost for each plan.
On sheet named 1.24.15 Column A and B are Employee First and Last Names. Column M I have created a drop down list where I can select from the list of plans. I want to auto populate Column N with the corresponding weekly payroll deduction based on the Plan selection I make in column M.
I am a not a beginner but still a basic user and I tried to google options for this desired result. I found and tried the following but ended up with: #NA error. =VLOOKUP(M2,DATA!A2:B5,2,FALSE)
I am using Excel 2013.
Thank you for any help you can provide.
Bookmarks