select item Auto

[majidsiddique]

Hi all,
i have a problem in selecting the item based of item category. can anybody tell me.


[TABLE="width: 620"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]No[/TD]
[TD]Item Category[/TD]
[TD]Item -Code[/TD]
[TD]Item Description[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]V[/TD]
[TD]A-ADJ(EXMPT)[/TD]
[TD]Adjustment of Exmpt Goods[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]V[/TD]
[TD]A-ADJ(TAX)00[/TD]
[TD]Adj of Taxable Goods[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]V[/TD]
[TD]ACC-3JFC0380[/TD]
[TD]Diagno Guide Wire 0.038'J' 150[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]V[/TD]
[TD]ACC-5TPL2400[/TD]
[TD]TEMPORARY PACING LEAD 5F[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]V[/TD]
[TD]ACC-6TPL2400[/TD]
[TD]TEMPORARY PACING LEAD 6F[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]V[/TD]
[TD]ACC-AC111100[/TD]
[TD]INTRODUCER NEEDLE[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]V[/TD]
[TD]ACC-BA051000[/TD]
[TD]INTRODUCER NEEDLE[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]C[/TD]
[TD]AM-030902[/TD]
[TD]COR-KNOT QUICK LOAD(12XSINGLE POUCH)[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]C[/TD]
[TD]AM-030925[/TD]
[TD]COR-KNOT DEVICCE[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]C[/TD]
[TD]AM-030950[/TD]
[TD]COR KNOT QUICK LOAD(PACK OF 6XPOUCHES)[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]S[/TD]
[TD]AM-031400[/TD]
[TD]COR-KNOT DEVICE MINI[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]S[/TD]
[TD]AM-20-0378[/TD]
[TD]FORCEPS APPLYING BULDOG CLAMP[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]S[/TD]
[TD]AM-AL0190.1[/TD]
[TD]JARIT 110-170 HANDLE KNOFE 3 LONG[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]S[/TD]
[TD]AM-AL2025.1[/TD]
[TD]AESCULAP FE783K YASARGI APP CLIP[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]S[/TD]
[TD]AM-AL2027.1[/TD]
[TD]AESCULAP FE783K APPLYING CLIP[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]S[/TD]
[TD]AM-AL2046.12[/TD]
[TD]AESCULAP FE783K YASARGI APP FORCEP STD[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]S[/TD]
[TD]AM-AL2430.1[/TD]
[TD]WECK 478178 CLAMP PEON 10`[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]V[/TD]
[TD]AM-AL8450.12[/TD]
[TD]GEISTER 34-7852S PUSHER KNOT VELVEGATEX1[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]V[/TD]
[TD]AM-B9324[/TD]
[TD]TITANIUM LIGATING CLIP MEDIUM-WIDE(BLUE)[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]V[/TD]
[TD]AM-BLM-22150[/TD]
[TD]MIST-BLOWER[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]C[/TD]
[TD]AM-CT-0050[/TD]
[TD]IMA BLADE HOOK(1705 SET)[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]C[/TD]
[TD]AM-CT-0052[/TD]
[TD]OPEN IMA DUAL HOOK(1705 SET)[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]C[/TD]
[TD]AM-CT-0100[/TD]
[TD]PIVOTING RETRACTOR 150MM RACK(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]C[/TD]
[TD]AM-CT-0114[/TD]
[TD]LIGHTED BLADE LOWER RIB 45X35MM GREEN(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]C[/TD]
[TD]AM-CT-0115[/TD]
[TD]LIGHTED BLADE UPPER RIB 45X35MM GREEN(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]C[/TD]
[TD]AM-CT-0124[/TD]
[TD]LIGHTED BLADE LOWER RIB 45X50MM RED(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]C[/TD]
[TD]AM-CT-0125[/TD]
[TD]LIGHTED BLADE UPPER RIB 45X50MM RED[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]S[/TD]
[TD]AM-CT-0134[/TD]
[TD]LIGHTED BLADE LOWER RIB 45X70MM BLUE(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]S[/TD]
[TD]AM-CT-0135[/TD]
[TD]LIGHTED BLADE UPPER RIB 45X70MM BLUE(CT-1000 SET)[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]S[/TD]
[TD]AM-CT-0144[/TD]
[TD]LIGHTED BLADE STERNAL 50X60MM ORANGE(CT-1000 SET)[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 285"]
<tbody>[TR]
[TD="class: xl65, width: 112"]S-SURGICAL Item[/TD]
[TD="class: xl65, width: 121"]V-VASCULAR ITEM[/TD]
[TD="class: xl65, width: 52"]C-CRHF
[/TD]
[/TR]
</tbody>[/TABLE]

I WANT "S" item list reflect in S-Suugical and same on "V" and "C"

thanks.

 

[nemmi69]

Are you doing this with formulas or VBa?

 

[majidsiddique]

hi nemmie69,
with formula.
thanks to reply.

 

[majidsiddique]

hi,
i am using this formula.
=IF(B2=LEFT($G$3,1),VLOOKUP(LEFT($G$3,1),B2:$D$31,2,0),0)
but result is not come perfectly.
can anybody help me?
thanks

 

[majidsiddique]

hi all,
in vlookup when condition false result is ZERO. i dont want Zero and any blank of gap cell. kindly tell how to do this?
Thanks.

 

[majidsiddique]

hi all,
can anubody help me?
Thanks.