create a macro if else statement

[aysrun]

hi i want to create a macro but im not too sure how for i am quite new in Excel.

i want this macro to read a value from a cell and from there return a value that i have set to.
say,
if A2 = LX1
return 6;
else if A2 = UG2,
return 12;
.....

i have arnd 30 values here that return either a 3, 6, 9 or 12.
any ideas how to start?
is a switch table more accomodating?
and furthermore LX1 may have 2 more possibilities that its either a 9 or 12.
so like
if A2 = LX1,
it can either return a 9 or 12.
how? help!

[TRJJK73]

Can you explain it more like what are the other possibilities etc.,.
it will be more nice if you post a workbook with dummy data.

[mudraker]

if A2 = LX1,
it can either return a 9 or 12.

You will need to provide more details so the macro code will be able to determine if it is a 9 or the 12 that is to be returned.
Or do you want the macro to try and guess which one you want returned?

Where are the values to be returned to

It is possible that you may be able to acheive what you want from a Vlookup formula

[aysrun]

found a way alr (: thanks.
i made a macro with 'if-else' statement. and abt the 9 or 12, its not needed yet.
thanks!!