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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,343
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,344
Messages
5,547,377
Members
410,790
Latest member
EvdM
Top