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.
|