Excel 2007 : Data Validation Lists with IF statements

[bradley2012]

I have two data validation lists, one with first names and one with last names. I'm trying to write an IF statement that gives the address when the names are picked (BOTH criteria met) but also shows an error when the names do not match.
I have been playing around with it, but can't seem to get it to work out right.
Thanks for the help

[NBVC]

Try something like:

=Index('Sheet2'!C$1:C$100,Match(1,('Sheet2'!$A$1:$A$100=A1),('Sheet2'!$B$1:$B$100=B1),0))

Confirmed with CTRL+SHIFT+ENTER.. instead of just Enter

Where Sheet2!A1:C100 contains database and column C has the addresses.... you can copy formula to the right to extract more data, if it exists in columns D, E, etc...

and where A1 and B1 contain drop downs in current sheet.

The formula will return #N/A error if no exact match found (first and last names).

Note: After you adjust ranges/references to suit, you need to re-confirm with CSE keys.