Jump to content
|Topic||Stats||Last action by|
|The Big Wrestling Thread!||
|Brown Ferguson: Jury decision not to charge sparks riot||
|Use OneNote tools to make holiday shopping fun again||
|W10 9879 - svchost problem||
|Displayport causing nVidia driver crashes ?||
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.