So am trying to use VLOOKUP (or perhaps another way) where based on the value of 2 columns, I get a certain value in 2 other columns.


For example:

First Name Last Name City State



So if I put in a City (Column C) and State (Column D) Combination, then I get the First (Column A) and Last Name (Column B) (both on another tab of the worksheet) of the Sales Person. But an error if the City and State are not valid.


Any help would be greatly appreciated!