Vlookup

Resolved · High Priority · Version 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:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips