if with multiple conditions in excel

[vlavan08]

hi frds,

below is my query,

I have set of 16 digits numbers in a column. there is a another column based on this column. Let the columns be C & D. Baed on the last 2 digits of the column c , column D value should get changed.

I have following conditions.

if the no ends with

22 ---- AAAA
33-----BBBB
44-----CCCC
55----GGGG

i used the following condition using right and if. but it didnt work. can any one help me pls..

=IF(RIGHT(C2,2)=F3,G3,IF(RIGHT(C2,2)=F4,G4,IF(RIGHT(C2,2)=F6,G6,"Not Listed")))

 

[Somendra Misra]

Hi,

See the file.

Or try changing your formula to
=IF(RIGHT(C2,2)=$F$3,$G$3,IF(RIGHT(C2,2)=$F$4,$G$4,IF(RIGHT(C2,2)=$F$6,$G$6,"Not Listed")))

Regards,

 

[vlavan08]

hi frd,

I can use only 2003 version...

below is my file

 

[vlavan08]

I got it frd. thank you

 

[Somendra Misra]

@vlavan08

See the file.

Regards,