Writing VBA Macro or Excel Function

Hi all,
I have Asset Class in Column I and if it is 364A-EL or 365A-EL or 368A-EL or 368B-EL or 369A-EL or 371A-EL or 371B-EL or 373A-EL or 397C-EL then 'POLES' assigned in to Owner Class (Column J).

If Asset Class is 366A-EL or 367A-EL or 367B-EL or 368C-EL or 369B-EL or 371C-EL or 373B-EL then assign UGCBL to Owner Class.

Should we write the macro or can it be accomplished by any Excel Function?

Could you please help in writing the Macro or Function, PLEASE ?

Thanks,
Venkat.

Hi Reafidy,

Thank you for your reply.

Depending on the values in Asset Class (Column I) I wanto to assign POLES or UGCBL or XXXX into Owner Class (Column J).

You are asking to list first values in column K and second list of values in column L, but I can not list those values into two separate columns, PLEASE?

Thanks,
Venkat.

They don't need to occupy a full column; they can be in any named ranges tucked away anyplace on the sheet, or elsewhere in the workbook.

You really don't want to hard-code these into a big long formula.

... but if you did, the formula would look like,

=if( or(A1 = {"blah1", "blah2", "blah3", ....}), "POLES", if( or(A1 = {"blahx", "blahy", "blahz", ...}), "UGCBL", "neither") )

Hi shg,
Thank you for your reply.

I am working on SAP BW BEx Report and I am trying to accomplish the requirement on front-end side instead of doing it on back-end.

I have entered the function as:

=IF( OR(I20 = {"364A-EL","365A-EL","368A-EL","368B-EL","369A-EL","371A-EL","371B-EL","373A-EL","397-EL"}),"POLES"), IF( OR(I20 = {"366A-EL","367A-EL","367B-EL","368C-EL","369B-EL","371C-EL","373B-EL"}),"UGCBL"), IF(I20 = "370A-EL","METER") and it was giving the error '#VALUE!'.

Next I changed it to the following and got the same error '#VALUE!':

=IF( OR(I20 = {"364A-EL","365A-EL","368A-EL","368B-EL","369A-EL","371A-EL","371B-EL","373A-EL","397-EL"}),"POLES"), IF( OR(I20 = {"366A-EL","367A-EL","367B-EL","368C-EL","369B-EL","371C-EL","373B-EL"}),"UGCBL")

Next I have tried with only partial data and worked correctly and gave 'POLES' for the First Row:

=IF( OR(I20 = {"364A-EL","365A-EL","368A-EL","368B-EL","369A-EL","371A-EL","371B-EL","373A-EL","397-EL"}),"POLES")

Some how it is not working for the second IF.
Could you please verify the syntax and help me, PLEASE ?

Thanks,
Venkat.

Misplaced paren:

=IF( OR(I20 = {"364A-EL","365A-EL","368A-EL","368B-EL","369A-EL","371A-EL","371B-EL","373A-EL","397-EL"}),"POLES", IF( OR(I20 = {"366A-EL","367A-EL","367B-EL","368C-EL","369B-EL","371C-EL","373B-EL"}),"UGCBL", "neither") )

Hi shg,
Thanks a lot for your great help. It WORKED !!!

Regards,
Venkat.