Jump to content
|Topic||Stats||Last action by|
|LG 34UM95-P Ultra wide monitor review||
|HP replaced motherboard...can't activate windows 8.1 pro.||
|Selling my computer. What can I realistically get for it?||
|Apple CEO Tim Cook Publicly Comes Out as Gay in Letter Declaring Support for Equality||
|Microsoft Band and Microsoft Health Thread||
Posted 02 February 2013 - 13:49
Posted 02 February 2013 - 14:11
Posted 02 February 2013 - 14:22
Just matching on Location?
is Location unique -
Either way, you can do this easily using the match function.
Posted 02 February 2013 - 15:32
Posted 02 February 2013 - 15:43
Posted 03 February 2013 - 10:15
='[Excel 1.xlsx]Sheet1'!$A2This will be your 'base' set of values to check against.
=MATCH(A2,'[Excel 2.xlsx]Sheet1'!$A:$A,0)This returns either the location in the array the exact value (the third argument means 'exact') is found or #N/A if not found.
=IF(ISNUMBER(B2),OFFSET('[Excel 2.xlsx]Sheet1'!$B$1,B2,0)-1,"NOT FOUND")Weight is similar.
Edited by laycat, 03 February 2013 - 10:17.