MM, your problem would be ideally suited to do with database software, such as Microsoft Access. Otherwise, you'd need VBA (Visual Basic for Applications) code to do it in Excel. I wrote some code (to brush up on my VBA for Excel skills) - the problem is there's a million ways to do it, and I'm not at all sure my solution is the simplest and/or best suited for what you're doing. (Actually, it's a bit overly complex at the moment.) But it works.

I'm posting it here for you to play with, but I can make adjustments for you tomorrow (and explain how to use it if need be):

Sub findfill()
    Dim mySheet As Worksheet
    Dim r As Range
    Dim rKey As Range
    Dim i As Integer
    Dim rLkup As Range
    Dim rDest As Variant
    
    Set mySheet = Worksheets("Sheet1")
    'manually set the range to run this program against:
    Set r = mySheet.Range("a2", "a14")
    For i = 1 To r.Cells.Count
        If r(i) = "" Then
            Set rKey = Cells(r(i).Row, r(i).Column + 1)
            r(i).Value = rKey
            Set rLkup = LookupKey(rKey.Value)
            If rLkup Is Nothing Then
                'do nothing - no match found
            Else
                Set rDest = Range(Cells(r(i).Row, r(i).Column + 2), Cells(r(i).Row, r(i).Column + 4))
                rLkup.Copy (rDest)
            End If
        End If
    Next i
    
End Sub


Private Function LookupKey(vIn As Variant) As Range
    Dim r2 As Range
    Dim rRet As Range
    Dim i As Integer
    Dim lkupsht As Worksheet
    
    Set lkupsht = Worksheets("Sheet2")
    'manually set the range for the lookup data to be used:
    Set r2 = lkupsht.Range("a1", "a10")
    For i = 1 To r2.Cells.Count
        If r2(i) = vIn Then
            Set rRet = Worksheets("Sheet2").Range(lkupsht.Cells(r2(i).Row, r2(i).Column), lkupsht.Cells(r2(i).Row, r2(i).Column + 2))
            Set LookupKey = rRet
                               
            Exit For
        End If
    Next i
End Function

You'd have to customize it for the range you're running this against and the range of the data on sheet 2 you're looking up. I put comments (i.e. the lines preceded by a ') before the lines you'd need to adjust. Also not that it expects the two sheets to be called "Sheet1" and "Sheet2".

'findfill()' is the subroutine that you'd actually run.

Surprise, surprise. The culprit in my Internet fiasco was, in fact, motherfucking Norton. I don't know why it suddenly started doing it now, but it has apparently decided it really does not play well with AVG or something. After I disabled it and let the AVG update finish downloading, things worked again. After I enabled it again, the problem came back. So I finally went in and told it to shut up and never come back on again unless I say so. I think the only additional benefit Norton provided me was a Firewall, and Windows XP comes with a firewall. Should I enable it? I don't think AVG Free 8.0 has a Firewall, just a "Resident Shield," which doesn't seem to be the same thing.

I can't find the url for estimating signal strength/directionality for dtv. It showed by address estimated strengths and whatnot per channel.

yes, put on Windows XP firewall.

yeah, I'm not surprised it is Norton.

I can't find the url for estimating signal strength/directionality for dtv. It showed by address estimated strengths and whatnot per channel.

omnis_audis talked about it back in April 6, 2008 omnis_audis "Buffistechnology 3: "Press Some Buttons, See What Happens."" Apr 6, 2008 1:15:36 pm PDT

Signal strength website is here.

Thank you!

who is that masked stranger quoting me so well?

Back to the phone thing. Laga, my MagicGate arrived today. You want me to call you on it?

The voip? Sure, call me tomorrow though- I'm at work 'till almost 11. Do you have my home number?

does it end in 71?

Tomorrow I'll get home around 6ish your time.

yep, that's the one. Sounds good. I'll text you if it looks like I'll be out but right now I have no solid plans.