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
|