Solved

how to fix the excel

Posted on 2016-07-20
3
124 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 51

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 31

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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