none
Drop Down Menu issue RRS feed

  • Question

  • I am using Excel 2016 and I have created a drop down menu with 25 employee names =$A$42:$A$66.  In the next column I am using this formula to pull there hourly wage =LOOKUP(B6,A42:A66,B42:B66). The problem that I am having is an employee with an A name gives me #N/A in the wage column and other employees give the wrong hourly wage.

    Please help.

    Sincerely,

    Bill

    Monday, December 28, 2015 8:46 PM

Answers

All replies