I have dropdown list in A7, and VLOOKUP in C7, if A7 is blank then I need C7 is also blank, which formula I am using giving error " N/A "
=VLOOKUP($A$7,table,2,FALSE)
Any help, Thank you