Thank you for the reply Tom, is it possible to do it without selecting the
cell using VBA ??
--
Les


"Tom Ogilvy" wrote:

Turn on the macro recorder and use the find method (in the edit menu) to find
you target in A.

once you have that code, then add this to it.

sB = activecell.offset(0,1).Text
sC = activecell.offset(0,2).Text
sD = activeCell.offset(0,3).Text

--
Regards,
Tom Ogilvy


"Les" wrote:

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