Hi, I'm trying to use an IF and VLOOKUP fx in the Data/Valiation/List feature but can only get half of it to work. For illustration, I have a list of values A1:A4 that may or may not have a corresponding value in B1:B4. If ColA does not have a corresponding value in ColB than I want it to display the entire list in C1:C4 in D1:D4.
A B C D
1 Red Circle one
2 Blue two
3 Yellow three
4 Green Star four
I'm open to new suggestions/approaches to getting the same results. Any help would be appreciated!
A B C D
1 Red Circle one
2 Blue two
3 Yellow three
4 Green Star four
I'm open to new suggestions/approaches to getting the same results. Any help would be appreciated!