Lookup two values - return one value

[JWJ3640]

I have two client name listed on separate sheets. Same format in terms of Last Name, First Name, then values.

I want to look up the Last Name (Column A) then First Name (Column B), and return the value in Column D.

Some of the values on 2nd sheet have blanks for the values to be returned.

How can I return the values to the first page?

1st Sheet Below

Last Name

First Name

Middle Initial

Address1

Address2

City

State

ZIP

Business Tel

Home Tel

Fax

Email

ID

DOB

Age

Returned Values

2nd Sheet Below

Last Name

First Name

Company

Automatic

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)