Thread: Vlookup ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Vlookup ?

I have 1000 names on sheet data 1! Column H
On sheet data 2! I have all the same names in Column H, except 2 are missing
( only 998 names)

Can I do a Vlookups in column Z of either/or both sheets that would show
what names are missing ? I'm trying to reconcile two differernt data sources.

Something like -- If same names are on both sheets,"", if Not "ALERT" or the
actual name would be ok too.

And vice-versa, if name on data 2! but not on data 1!

Much thanks,

Steve