View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave1979jCIOH Dave1979jCIOH is offline
external usenet poster
 
Posts: 1
Default Help with VLOOKUP?

Lets say I have column A1-A5 labeled as weeks 1-5 and will choose a different
person to go in column B1-B5 each week. Below column B1-B5 in B7-B11 I have
each person's name from which I will choose. Is there a formula or function
that can be used that will replace each person's name with an "X" in B7-B11
as they are filled in each week in B1-B5?

I am thinking it may be some sort of IF statement with a Vlookup formula.
If so, doe that require listing the names again in column B below B7-B11?