Jump to content
|Topic||Stats||Last action by|
|Hacker/leech on my network and I can't get 'em off||
|Burger King worker's shocking find -- $100 K||
|Router Strength Through TV||
|I'd Ask you how your thanksgiving was but..||
|Goruck gear on sale (black friday)||
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.