Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup values, compare and paste
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup values, compare and paste
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 --------------- Jacob Skaria "Willis_p" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare and copy/paste | Excel Worksheet Functions | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
lookup in colum a and compare values in colum b | Excel Worksheet Functions |