I'm having a small issue with AWK:

I run this in PUTTY:

awk 'BEGIN{FS=","}NR==FNR{A[$1]=$1;next}{if (A[$1]==$1) print $0}' FILE1 FILE2

 #VLOOKUP type funtion useing AWK
BEGIN{FS=","}
NR==FNR
{A[$1]=$1;next}
{if (A[$1]==$1) print $0}

 awk -f ultVlookup.awk FILE1 FILE2

The NR==FNR controls whether the code block behind it runs.

When you put the code block on a different line, the statement is used for a different purpose -- determines whether the line prints. And the code block, without anything in front of it, runs every line, and the last line is never run because of the 'next' in the line above.

BEGIN{ FS="," }
NR==FNR {A[$1]=$1;next}
{if (A[$1]==$1) print $0}