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
Bookmarks