how to fix the excel

Posted on 2016-07-20
Medium Priority
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.


Question by:ammartahir1978
LVL 54

Accepted Solution

Rgonzo1971 earned 1400 total points
ID: 41721515

pls try


Open in new window

LVL 35

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 600 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

Open in new window

and copy it down.

In M2

Open in new window

In M3

Open in new window


Author Closing Comment

ID: 41721718

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

627 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