RDEXCEL2020
Member
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)))
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)))