Jump to content
|Topic||Stats||Last action by|
|Formula 1 World Championship 2015 Season Discussion||
|"Surface 3" will have Intel Atom Cherry Trail and 4G LTE||
|The Big Wrestling Thread!||
|Ex-CFO who slammed Chick-fil-A now on foodstamps||
|Windows XP nostalgia||
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.