Vlookup/CountIf issue

Ianwillo123

New Member
Joined
Oct 19, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I have a table or contains data like the below and as you can see there are some duplicates of IDs;

ID
966368
1004275
1004275
1004275
998516

What I’m trying to do is on another table on another sheet (milestonesis count how many times the ID exists.

I am using a vlookup but it’s not working, can anyone help where I am going wrong?

=Count(vlookup[@[id],Milestones[#all],3,false))

Thanks all
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,345
Without seeing your actual layout, it's hard to tell what you want, but maybe you want COUNTIF or COUNTIFS?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,421
Messages
5,547,824
Members
410,813
Latest member
Vhinzvirgo
Top