Solved

how to fix the excel

Posted on 2016-07-20
3
118 Views
Last Modified: 2016-07-20
Hi All,

I have this excel with 3 tabs.

i want to put the Barcode in TAB 1 (Pickrate aganst the products from TAB 2 (Barcodes).

then i want to calculate how many products we have sold have barcode and how many with out barcode.

What percentage of products picked have barcode of the total sales.

When i put my simple vlookup it doesnt work can someone help please.

regards,

AT
Comparison.xlsx
0
Comment
Question by:ammartahir1978
3 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 350 total points
ID: 41721515
Hi,

pls try

=IFERROR(VLOOKUP(A2,Barcodes!C:F,3,0),"")

Open in new window

Regards
0
 
LVL 30

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 150 total points
ID: 41721652
Your Vlookup Formula didn't work because in Vlookup Formula, the lookup value should be in the first column of the table_array which is not the case in your Vlookup formula.

Please try this......

In F2
=IFERROR(VLOOKUP(A2,Barcodes!C:F,3,0),"")

Open in new window

and copy it down.

In M2
=SUMPRODUCT(--ISNUMBER(F2:F4616))

Open in new window


In M3
=SUMPRODUCT(--(F2:F4616=""))

Open in new window

0
 

Author Closing Comment

by:ammartahir1978
ID: 41721718
excellent
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question