I've got what's probably a simple question concerning Microsoft Excel 2013 that I just can't figure out the answer to.
I have cell A1 that contains a name in the form of two words, such as "Jane Doe".
In two separate columns, I have separate lists of first and last names.
Here's what it looks like:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">
</code>
<tbody>
</tbody><code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">
</code>
Here's what I'm trying to do: I'm trying to set up a validation rule in A1 that dissalows entering a two -word name that doesn't match a combination of columns B and C on some row.
How can I accomplish this?
Any and all help is much appreciated.
I have cell A1 that contains a name in the form of two words, such as "Jane Doe".
In two separate columns, I have separate lists of first and last names.
Here's what it looks like:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">
</code>
A | B | C | |
1 | Jane Dooey | Jane | Doe |
2 | Jane | Dooey | |
3 | John | Dooey | |
4 | John | Doe |
<tbody>
</tbody>
</code>
Here's what I'm trying to do: I'm trying to set up a validation rule in A1 that dissalows entering a two -word name that doesn't match a combination of columns B and C on some row.
How can I accomplish this?
Any and all help is much appreciated.
Last edited: