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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
10,486
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,118,861
Messages
5,574,709
Members
412,613
Latest member
EFRATA
Top