Lookup values, compare and paste

[Willis_p]

If two cells on the same row have values that have been identified by a
VLookup formula, how do I compare both to a master list on a following page
and return a value from that following page to a different cell on page1?

 

[Jacob Skaria]

If i understand you correctly; you are trying to get the information from a
master list with 2 matching fields..Suppose in Sheet1 you have the data as
below (master sheet)

Col A Col B Col C
Emp Code Name Office
10001 Tom R Bath
10002 Katy C Bath
10003 Nigel G Bath
10004 Pete R Bath
10005 Tony A London
10006 John B London
10007 Mary C London
10008 Jane D London

In Sheet2 you have the employee name and office location in cell A1,cell B1
Col A Col B
Katy C Bath

To retrive the employee code from master sheet (Sheet1) with the 2 fields
available in sheet2 try the below array formula. You create array formulas in
the same way that you create other formulas, except you press
CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar' you can
notice the curly braces at both ends like "{=<formula>}"

=INDEX(Sheet1!$A$2:$A$9,MATCH(1,(Sheet1!$B$2:$B$9=A1)*
(Sheet1!$C$2:$C$9=B1),0))


If this post helps click Yes