I have a drop down menu consisting of (3,4,5,7.5 Single Compressor,7.5 Dual Compressors,8.5,10,12.5,15,17.5,20 and 25. when I use a vlookup using this dropdown menu as a reference everything works perfect except for when I select 7.5 Dual Compressors, i get #N/A for all of my values why is this?
Solved by C. Y. in 11 mins