View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wilmaloney wilmaloney is offline
external usenet poster
 
Posts: 2
Default Is there a formula that doesn't change current cell if false?

I have a large spreadsheet and I regularly paste out a small section and get
many people to update fields. I then want excel to find this small section
(via Vlookup) and return the new updates. If the result in the main sheet is
false ie; current cell is not part of the small selection and cannot be
found, I want the cell to be unchanged. This allows me to keep the main sheet
updated as time permits.