Calculation

Hi Team,

I have scenario  where i do have materials

M1,M2,M3.........M50

If i select M2 i need to get equivalent part M4,M30

and if i select M5 i need to get equivalent materials likes M8,M12,M21,M29 and so on.

How can i achieve this.able to write a query for this

select distinct material_number(dim1) from table1 where dim2 in (select distinct dim2 from table1 where  country='India')

i am getting the values from backend.

From sheet1 when i click MK48483727 then i need to get some random material numbers.

Same if i execute from backend i am getting a value like ML25925927,MK48483728,ML25925928,MK48483729

Can someone please help.