Setting Value In One Cell Based On Another

[Girac]

Hi all,
I need a macro to set the value of cell E$ based on the LIKE VALUE of V$.

Example, V$ are product codes follow the convention of:
"Prod group, *, 4-6 digits (1234 are an example)"
"2*1234" = Prod group1
"3*1234" = Prod group2
"4*1234" = Prod group3

I need to set the value of cell E$ to "Prod group1, Prod group2, Prod group3" based on the above example:

I looked at the RANGE function but that isnt working for me.
Can anyone assist in this,

TIA

 

[al_b_cnu]

Hi,

Maybe a VLookup:

Book2
	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
2	Product Group 1																	2*1234		2	Product Group 1
3	Product Group 3																	4*9876		3	Product Group 2
4	Product Group 2																	3*13579		4	Product Group 3
5
6
7
Sheet1

formula in E2 is =VLOOKUP(LEFT(V2,FIND("*",V2)-1)+0,X:Y,2,FALSE)
note the lookup table in X2:Y4