Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I match one list vs another using VLOOKUP?
- Thread starter Nullsweat
- Start date
bluedragon2
IS-IT--Management
=IF(VLOOKUP(A1,$D$1:$D$100,1)=A1,"In the List","Not in the List")
and copy for each name in the second list.
The A1 refers to the start of the second list and the D1
100 refer to the orginal list.
[Blue]Blue[/Blue] [Dragon]
If I wasn't Blue, I would just be a Dragon...
and copy for each name in the second list.
The A1 refers to the start of the second list and the D1
100 refer to the orginal list.[Blue]Blue[/Blue] [Dragon]
If I wasn't Blue, I would just be a Dragon...
- Status
Similar threads
- Locked
- Question