extract relevent data information in other cells

Why not set up a table on sheet 2 where column A was a b c d and column B was Apples, Bananas, Carrots and Dominoes etc
then in column B (of Sheet 1) put
=VLOOKUP(A1,Sheet2!$A$1:$B$20,2,TRUE)
(enter the formula in B1 and formula-fill downwards as required)

Any code in column A will be reflected correctly in column B

hth
---

Originally Posted by stevekirk

hi,

i have a wookbook that has codes in a range of cells. the codes could very in each cell evey time i run the macro

there are 20 different codes and discriptions.

each code has a description with it
each code could repeat itself when i run the macro
i want to be able to put the relevent discription once with the code even if the code has repeated itself

ie

a=apples
b=beans
p=pears
etc

a1 could have "a" in it
a2 could have "a" in it
a3 could have "b" in it
a4 could have "p" in it

i would like to see a matrix that just shows the code description once if the code is in the column a

the codes in cell a1,a2,a3,a4 could change the next time i run the macro

hope this helps
thanks

steve