Populate Adjacent Cells from Validation List Entry

I am using several validation list and would like to auto-populate adjacent cells with the validation list selection. I found that VLOOKUP is the best option for this but can't get the formula to work. I have a validation list with two values (YES, NO) and a list with ten values (A, B, C, D, E, etc.). Any suggestions?

Here's the attachment and here's the formula:

=IF(C1="","",VLOOKUP(C1,{"YES";"NO"},2,0))

I'm trying to fill in cells C2-C37 with the value entered in C1.

That did the trick but leaves a 0 if C1 is empty. Can the formula make the adjacent cells empty if C1 is empty as well?
Thanks

Originally Posted by davesexcel

What are the 10 values you are refering to?

Can't really say what they really are...sensitive work stuffs. They're basically short text strings 5-8 characters in length.

Oh, that...figured I'd just include the first example and mimic that in the second instead of uploading both. I'd have to do a bit of scrubbing to remove the sensitive stuff. Quicker just uploading the first.

Thanks so much.

Hello everybody,
can somebody help me out on this:
I need to design an Excel Template such that when a selection is made from a list under a column "Account type" with values 1,2,3,4, this should automatically update the content of the list in the adjacent cell under column "Account No" with list values Orange, Mangoes,Guava for Value 1 under Accout Type; list values Tiger, Goat, Cat for Value 2 under Accout type. Please, Treat as Urgent. Thanks in advance