Jump to content
|Topic||Stats||Last action by|
|Etoro? Anyone use it?||
|SteelSeries are selling a "Pro Gaming Suit" onesie||
|Windows 10 Technical Preview||
|Play Pac Man on your street with Google Maps||
|The Big Wrestling 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.