View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
D D is offline
external usenet poster
 
Posts: 121
Default Vlookup,Index,or Combo of something else

I have 2 worksheets. On Sheet1, if Column H value ="M", then on Sheet2:A2,
bring over the value of Sheet1:A2. If it doesn't find the value "M", then
search for the next row that does.