View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
D. D. is offline
external usenet poster
 
Posts: 53
Default IV,, VLOOKUP or both??????????????????


I can't really tell what the sheet looks like, but
=If(k1=$A$6,"X","")

adjust the cells refferences to what you need, because I can't tell