View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default Find value then offset, to set variables

Good day, i am not a programmer but a dabbler and have a range called
"Projects" with the following in it:
A B C D

PU 03/07 90ZA0703 90IH0703 PU0703LCS
PU 09/07 90ZA0709 90IH0709 PU0907LCS
PU 03/08 90ZA0803 90IH0803 PU0803LCS
PU 09/08 90ZA0810 90IH0810 PU0809LCS

What i need to do is look up the value in "A" and then set 3 string
variables with the values in "B", "C" & "D" to the right of the value found
in "A".

Any help with code would be very much appreciated...

--
Les