Since I had a little time to kill...

Assuming your 1st file is named 'f1.txt' and your 2nd is 'f2.txt': 

use warnings;
use strict;

my %areas;
my $file;
my $fh;

$file = 'f2.txt';
open $fh, '<', $file or die "Can not open file $file: $!";
while (<$fh>) {
    next if $. == 1;
    my ($name, $area) = split;
    $areas{$name} = $area;
}
close $fh;

my $name_line = 0;
my $name;
my $area;
$file = 'f1.txt';
open $fh, '<', $file or die "Can not open file $file: $!";
while (<$fh>) {
    chomp;
    if ($. == 1) {
        print "$_    Area\n";
        next;
    }
    my @tokens = split;
    if (scalar @tokens == 1) {
        print "$_\n";
        $name = $tokens[0];
        $area = $areas{$name};
        $name_line = 1;
    }
    else {
        if ($name_line) {
            $name_line = 0;
            print "$_     $area\n";
        }
        else {
            print "$_\n";
        }
    }
}
close $fh;

__END__

Name  measure  Age    Area
Eric    
Test1   40     16     Texas
Test2   35     16.5 
Test3   60     27
Tets4   20     30

Dan
Test1   15     50     NY
Test2   22     70

[download]

In reply to Re^2: How to merge two files? by toolic
in thread How to merge two files? by kayj

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.