select item Auto

majidsiddique

Board Regular
Joined
Oct 22, 2018
Messages
164
Hi all,
i have a problem in selecting the item based of item category. can anybody tell me.


NoItem CategoryItem -CodeItem Description
1VA-ADJ(EXMPT)Adjustment of Exmpt Goods
2VA-ADJ(TAX)00Adj of Taxable Goods
3VACC-3JFC0380Diagno Guide Wire 0.038'J' 150
4VACC-5TPL2400TEMPORARY PACING LEAD 5F
5VACC-6TPL2400TEMPORARY PACING LEAD 6F
6VACC-AC111100INTRODUCER NEEDLE
7VACC-BA051000INTRODUCER NEEDLE
8CAM-030902COR-KNOT QUICK LOAD(12XSINGLE POUCH)
9CAM-030925COR-KNOT DEVICCE
10CAM-030950COR KNOT QUICK LOAD(PACK OF 6XPOUCHES)
11SAM-031400COR-KNOT DEVICE MINI
12SAM-20-0378FORCEPS APPLYING BULDOG CLAMP
13SAM-AL0190.1JARIT 110-170 HANDLE KNOFE 3 LONG
14SAM-AL2025.1AESCULAP FE783K YASARGI APP CLIP
15SAM-AL2027.1AESCULAP FE783K APPLYING CLIP
16SAM-AL2046.12AESCULAP FE783K YASARGI APP FORCEP STD
17SAM-AL2430.1WECK 478178 CLAMP PEON 10`
18VAM-AL8450.12GEISTER 34-7852S PUSHER KNOT VELVEGATEX1
19VAM-B9324TITANIUM LIGATING CLIP MEDIUM-WIDE(BLUE)
20VAM-BLM-22150MIST-BLOWER
21CAM-CT-0050IMA BLADE HOOK(1705 SET)
22CAM-CT-0052OPEN IMA DUAL HOOK(1705 SET)
23CAM-CT-0100PIVOTING RETRACTOR 150MM RACK(CT-1000 SET)
24CAM-CT-0114LIGHTED BLADE LOWER RIB 45X35MM GREEN(CT-1000 SET)
25CAM-CT-0115LIGHTED BLADE UPPER RIB 45X35MM GREEN(CT-1000 SET)
26CAM-CT-0124LIGHTED BLADE LOWER RIB 45X50MM RED(CT-1000 SET)
27CAM-CT-0125LIGHTED BLADE UPPER RIB 45X50MM RED
28SAM-CT-0134LIGHTED BLADE LOWER RIB 45X70MM BLUE(CT-1000 SET)
29SAM-CT-0135LIGHTED BLADE UPPER RIB 45X70MM BLUE(CT-1000 SET)
30SAM-CT-0144LIGHTED BLADE STERNAL 50X60MM ORANGE(CT-1000 SET)

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

S-SURGICAL ItemV-VASCULAR ITEMC-CRHF

<tbody>
</tbody>

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

thanks.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Are you doing this with formulas or VBa?
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top