View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Vlookup with duplicate unique items

I have a one master file with a worksheet like below that I send out to
multiple people,it's about 2k rows long:

A B C D
1 40921 John Booked Low risk

2 40922 John Booked

3 40923 John

4 40924 Peter

5 40925 Peter

6 40925 Peter

What I tried doing is copying all the worksheets that I get into one and
using a Vlookup to pull data from columns C and D into one sheet, but with
vlookup it pulls the first piece of data it finds so sometimes I end up with
a blank when I know data is present. Does anyone know of a formula that can
fit my needs?

JS