Shell Programming and Scripting

If it doesn't have to be awk, then this would probably do the job:

Code:

#!/bin/sh
while read file1line
do
  value=`echo "$file1line" | cut -d ' ' -f 1`
  user=`echo "$file1line" | cut -d ' ' -f 2`
  # Depending on your os, you might need egrep here instead of grep -e
  file2value=`grep -e " $user\$" $2 | tail -1 | cut -d ' ' -f 1`
  if [ -n "$file2value" ]
  then
    # We've found one
    value=`expr $value + $file2value`
    echo "$value $user"
  fi
done < $1

(Untested)

Usage:

Code:

  ./yourscript file1 file2 > outputfile

This will have the following potential issues:
If a user appears twice in the first file, it will be output twice as though it were two different users (use another grep over the first file to locate additional identical users to fix this if it matters).
If a user appears twice in the second file, only the last detected occurance of the user will ever be used (use a while loop on the second file to fix this if it matters).