Hi


I set a drop down box in Cell B1 and for some reason I get a result of #VALUE!. Sample attached. 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)))
Thank you.