Validate two words from cell using two other columns Microsoft Excel

[dskribow]

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>

	A	B	C
1	Jane Dooey	Jane	Doe
2		Jane	Dooey
3		John	Dooey
4		John	Doe

<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.

 

[Peter_SSs]

Ok, that makes more sense. Thank you, Peter_SSs.

You are welcome.

 

[dskribow]

Ok, so, I've actually got another related question. How can I make this work in VBA?

Here's what I'm trying to do: WorksheetFunction.Index(Sheet2.Range("Customer_Table"), WorksheetFunction.Match(Sheet13.Range("C3"), Sheet2.Range("Customer_Table[FName]") & " " & Sheet2.Range("Customer_Table[LName]"), 0), 1)

I keep getting a typ mismatch error.

...any ideas?

 

[Peter_SSs]

Here's what I'm trying to do:

Actually, you gave us some code that apparently doesn't do what you are trying to do. So how should we deduce what you are trying to do?

How related to the previous question is this?
We haven't previously learnt what Sheet2 and Sheet13 are and what "Customer_Table" is. Whilst we can guess, it would be good to know for sure. Also, what is this code part of?

Are you trying to use vba instead of the built-in Data Validation? If so, how and why?

The more background & understanding we have, the better chance of getting to the best solution quickly.

 

[dskribow]

Hi, Peter_SSs...was hoping that there was a simple syntax or logic error somewhere in there.


My issue is somewhat related to my precious data validation question, but I figured that I should create a new thread for it here: http://www.mrexcel.com/forum/excel-...ue-two-columns-visual-basic-applications.html