Drop down and Vlook up combination

[dropdown2014]

In excel 2013 I am trying to use a drop down menu result in a VLOOKUP table and I am getting a #N/A result. When I type into the result cell the VLOOKUP works fine. I have tried to use "=cell" number and I still get the "#N/A result".
Is there a way to get a valid result from a drop down menu?

Thanks

Colin

[Pete_UK]

If you are getting #N/A then you are looking for exact matches in the VLOOKUP formula, and clearly there is a mis-match between what you have typed in manually and the values that you have in the drop-down.

Check your data - if the lookup values are text values then you might have leading or trailing spaces (or multiple internal spaces), or this might apply to the values you are using for the drop-downs. If the lookup values are numbers, then they might actually be text values that just look like numbers within your table, or the same might apply to the drop-down values, or if they are proper numbers then they might be formatted to show a smaller number of decimal places than they actually contain.

Attach an Excel workbook (NOT a picture of one), so that we can investigate further for you.

Hope this helps.

Pete

[dropdown2014]

Thank you for reply, I have attached the file, I copied and pasted the lookup and still received the #N/A result. Appreciate you help

C

[Pete_UK]

Change your formula to this:

=VLOOKUP(B4,Sheet2!$B$3:$E$24,4,0)

you were trying to lookup on column D, and so there were no matches.

Hope this helps.

Pete

[dropdown2014]

Thank you Pete, that has fixed it, I moved things around and didn't check that.

Back to data entry now!

Colin

[Pete_UK]

Glad to be of help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[dropdown2014]

Thanks was looking for that.

Colin