Vlookup in a vlookup

[tabitav]

Good Day

I need some help please. Is it possible to run a vlookup in a vlookup? I'll
try to explain - I've got a master list of data, which is used to as the
basis for performance contracts set. I then have a second list, which are the
details of the actual performance contracts. Now I want to use a formula to
find the mast list details for the person and then match it to the actual
performance contract used - where there is a match. Is there a way one can
use vlookup or any other formulas to do this in Excel (using Excel 2007).

Here is an example of data in the master list:
-----------------------------------------------------
Master Job Objective Name
Job 1 Objective 1
Job 1 Objective 2
Job 1 Objective 3
Job 2 Objective 1
Job 2 Objective 2
Job 2 Objective 3
Job 3 Objective a
Job 3 Objective b
Job 3 Objective c

An example of the second list details:
-------------------------------------------
Employee # Master Job Contract objective
Person 1 Job 2 Objective 2
Person 1 Job 2 Objective 3
Person 1 Job 2 Objective new (not in master list)
Person 2 Job 2 Objective new 1
Person 2 Job 2 Objective new 2
Person 2 Job 2 Objective new 3

Summary - so I want to write a formula that will find Job 2 in the master
list and then see if the contract objective is listed in the master list for
Job 2.

Your assistance would be greatly appreciated.
Thanks

 

[Jacob Skaria]

Write vlookup1/vlookup2 formula separate and fit that into the below formula...

=IF(ISNA(vlookup1),"not in list 1",
IF(ISNA(vlookup2(vlookup1)),"not in list 2",vlookup2(vlookup1)))

If this post helps click Yes