View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Loz[_2_] Loz[_2_] is offline
external usenet poster
 
Posts: 3
Default how to vlookup returning a concatenation of 2 cells

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