Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

Vlookup

ResolvedVersion 2010

Wed 28 Jun 2017, 11:30 Delegate Leo said...

Leo has attended:
Excel Introduction course
Excel Intermediate course

Vlookup

hi, I am using lots of barcode now at my new job.
I would like to you a form (VLOOKUP) to find out how many the same barcod I got from coluna 1 to colune 2 and showing it on coluna 3.
hope you can help me with it

Colun1 Colune 2 Colune 3
889698129312 849803062446
889698139069 849803055295
849803094928 830395025964
849803092986 830395025964
849803063672 849803062453
849803077082 849803042967
849803045555 849803047795
849803046736 830395023007
849803042448 849803057091
849803038960 849803057794
849803037932 830395030128
849803095826 830395030876
849803092986 849803055776
849803060664 849803057640
849803038854 830395023212
849803037932 830395032696
889698129312 849803048761
889698136303 849803039929
889698136297 849803038762

Fri 30 Jun 2017, 14:12 Trainer Jens said...

RE: vlookup

Hi Leo,

Thank you for the forum question.

You can use a Countif function. in column 3 in the first cell type =Countif($A$2:$A$20,B2)

Copy it down.

You will have to amend the Countif if your first column is not column A and you will also have to change how many rows you want the countif to count.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 7 Jul 2017: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Vlookup

Vlookup

RE: vlookup

Excel articles

Excel tip:

Generating Random Numbers