Hi,

I was hoping someone could help me with a problem I have
please. I know (hope) it isn't too complicated, but I just
can't do it. My logic isn't computing. }:-s

I have 2 labels. $H$10 & $I$10.
I need code to read H10 and find it in Col B and return
the contents of Col C (Path) & Col D (Filename).
Then, if there is a label in I10 do the same.

I look forward to any assistance
Thank you!
Loz

=VLOOKUP(H10,B:D,{2,3}) array entered into a 2-column row

Alan Beban

Loz wrote:
Hi,

I was hoping someone could help me with a problem I have
please. I know (hope) it isn't too complicated, but I just
can't do it. My logic isn't computing. }:-s

I have 2 labels. $H$10 & $I$10.
I need code to read H10 and find it in Col B and return
the contents of Col C (Path) & Col D (Filename).
Then, if there is a label in I10 do the same.

I look forward to any assistance
Thank you!
Loz

this does not work for me :(
Excel XP

Patrick Molloy
-----Original Message-----
=VLOOKUP(H10,B:D,{2,3}) array entered into a 2-column row

Alan Beban

Loz wrote:
Hi,

I was hoping someone could help me with a problem I
have
please. I know (hope) it isn't too complicated, but I
just
can't do it. My logic isn't computing. }:-s

I have 2 labels. $H$10 & $I$10.
I need code to read H10 and find it in Col B and
return
the contents of Col C (Path) & Col D (Filename).
Then, if there is a label in I10 do the same.

I look forward to any assistance
Thank you!
Loz

.

Loz,
try this (adjust $B$1:$D$18 to suit)

Sub test()
For i = 8 To 9
If Not Cells(10, i).Value = IsNothing Then
If Not IsError(Evaluate("VLOOKUP(" _
& Cells(10, i).Address & ",$B$1:$D$18,2,0)")) Then
Cells(11, i).Value = Evaluate _
("VLOOKUP(" & Cells(10, i).Address & ",$B$1:$D$18,2,0)") & _
Evaluate("VLOOKUP(" & Cells(10, i).Address & ",$B$1:$D$18,3,0)")
End If
End If
Next i
End Sub

HTH
Cecil

"Loz" wrote in message
...
Hi,

I was hoping someone could help me with a problem I have
please. I know (hope) it isn't too complicated, but I just
can't do it. My logic isn't computing. }:-s

I have 2 labels. $H$10 & $I$10.
I need code to read H10 and find it in Col B and return
the contents of Col C (Path) & Col D (Filename).
Then, if there is a label in I10 do the same.

I look forward to any assistance
Thank you!
Loz