Guys I Need Help Please!!!

[MonioDee]

Guys what kind of formula should I used to identify the given amount once the given rows (name b2:b9) matches to the given columns (name d1:k1). sample I want to appear the amount of 10 to d2 when d1 matches to b2. guys please help me ive been working to this for many days already T_T

 

[rahulshewale1]

hiii,

Please find the attached solution .........

Formula 1--{=TRANSPOSE($B$5:$B$12)}
Formula 2--- $C5


Thanks
rahul shewale

 

[MonioDee]

Thanks Rahul shewale, but what if the details or values from d1:k1 became rumble, that's why I need a strong formula that could gave me the values from c2:c9 once datas from a2:a1 & d1:k1 matches.

 

[NARAYANK991]

Hi ,

Have you tried entering :

=INDEX($C$2:$C$9 , MATCH(D$1 , $B$2:$B$9 , 0))

in D2 , and copying it across ?

Narayan

 

[MonioDee]

Hi Sir here is my sample document, and my apology I havent work yet with VBAm please help me thanks

 

[MonioDee]

Hi ,

Have you tried entering :

=INDEX($C$2:$C$9 , MATCH(D$1 , $B$2:$B$9 , 0))

in D2 , and copying it across ?

Narayan

Yes sir Narayan Id try but it gave me wrong values, and still working on it getting hopeless already

 

[NARAYANK991]

Hi ,

See your file now.

Narayan

 

[MonioDee]

Hi ,

See your file now.

Narayan

Thank a lot sir NARAYANK I owe you one!! Have a great day!!!

 

[Syedali]

Hi Sir here is my sample document, and my apology I havent work yet with VBAm please help me thanksView attachment 43306

My try

 

[bosco_yip]

A simple IF function is enough.

In D2, formula copy across and down :

=IF($B2=D$1,$C2,"")

Regards

 

[Syedali]

View attachment 43312

A simply IF function is enough.

In D2, formula copy across and down :

=IF($B2=D$1,$C2,"")

Regards

Wow .. nice and simple...

 

[MonioDee]

View attachment 43312

A simple IF function is enough.

In D2, formula copy across and down :

=IF($B2=D$1,$C2,"")

Regards

OMG!!! hahaha i never imagine that Id been working with these for a days, that only has a simple solution just as simple as that, You made my day sir Bosco, Thanks a lot men have a greatest day!!! I owe you guys see you soon (^_-)