I have two sheet in one excel file, column A, B, C available on sheet 1 and F,G,H,I,J,K available on sheet two, i want to get count on sheet 2 G to K column, but on sheet1 A column have multiple name of one, so that i need to use it for Vlookup formula, but with Vlookup formula not give me counting on sheet2.
i also need one thing that when i put OUT on Sheet1 status column on that time i need to automatically remove that product on sheet2.
i also need one thing that when i put OUT on Sheet1 status column on that time i need to automatically remove that product on sheet2.
![ohkdqv.jpg](/board/proxy.php?image=http%3A%2F%2Foi60.tinypic.com%2Fohkdqv.jpg&hash=759486bc453e4b63e15e7f1eabd35d68)