• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

DATA VALIDATION #VALUE! ERROR

Hi

I set a drop down box in Cell B1 and for some reason I get a result of #VALUE!. I think the reason is because the length of the first selected is long.


How can I reset the code below:



=IF(C5="","",IF(VLOOKUP(C5,Refer,2)="", "", VLOOKUP(C5,Refer,2,FALSE)))
 

Attachments

  • Testing Data.xlsm
    13.6 KB · Views: 6
Hi Put your code in it but when I selected the PEACH in the dropdown box in B1 the selected did not appear in E7.

sorry about my engligh :eek:(
 

Attachments

  • Testing Data.xlsm
    13.6 KB · Views: 1
Yay! it works.
But is there a way, you can edit the code by putting "","" to make it blank where there nothing being selected in B1? Right now show #N/a.
Please...

Also, is there a way when I clicked the dropdown box and it will show the entire text for Peach. It look like it cut off and its not showing the entire text for peach. Like wrap text in the data validation. If its not possible its ok. Thank you
 

Attachments

  • Testing Data.xlsm
    15.1 KB · Views: 1
Hi
Perfect!! Thank you so much.

Last thing, is there a way to show the entire text on the Peach if I selected in the drop down box?
 
Back
Top