Hello,
I am attempting to return a blank cell with the below formula:
=IF(VLOOKUP(K35,$A$27:$B$30,2,0)="","",VLOOKUP(K35,$A$27:$B$30,2,0))
However, I continue to receive the #N/A error. My VLOOKUP range includes the below:
Cell K35 contains a Data Validation (list) range that is comprised of cells A27:A30. When I choose any option but the blank cell I receive the corresponding value, but when I select the blank cell as a dropdown option I get the #N/A error.
I am attempting to return a blank cell with the below formula:
=IF(VLOOKUP(K35,$A$27:$B$30,2,0)="","",VLOOKUP(K35,$A$27:$B$30,2,0))
However, I continue to receive the #N/A error. My VLOOKUP range includes the below:
Cell K35 contains a Data Validation (list) range that is comprised of cells A27:A30. When I choose any option but the blank cell I receive the corresponding value, but when I select the blank cell as a dropdown option I get the #N/A error.