Hi guys,
Is it posible to use vlookup to retreive multipule Job No. from a list?
eg ,
Job No.-------Part No.----------- Qty.
g33116 ------- bla----------------- 5
bla------------ bla-----------------4
33116g--------bla-----------------3
bla------------bla-----------------2
33116---------bla-----------------1
I would like to pull out all the Job No's with 33116 in them onto a new worksheet to hand out as a report.If anyone would point me in the right direction i could possible save up to 45min a day!!!
Thanks
Jono
Bookmarks