Formula required:

JohnGreig

New Member
Joined
Feb 21, 2021
Messages
7
Office Version
  1. 2013
Platform
  1. Windows
Example: for two cells A2 and C2 I am looking for a formula in A2 that will copy the final entry in C2 when the information from other parts of the spreadsheet are moved more than once into C2.
Such as cell entries elsewhere "abc", "def", "xyz" that can be moved in and out of cell C2 until satisfied with the final entry. It is the final entry in C2 that I want to see in A2.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
Should be
Excel Formula:
=INDEX(Sheet2!C:C,2)


.. or if the other sheet name has any spaces in it you need some single quote marks as well
Excel Formula:
=INDEX('Sheet 2'!C:C,2)
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

JohnGreig

New Member
Joined
Feb 21, 2021
Messages
7
Office Version
  1. 2013
Platform
  1. Windows
Thanks Peter, that works. One final question, if there is no entry in C2 on Sheet2 I would prefer A2 on Sheet1 to be blank rather than returning"0"
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
If the entry in C2 of Sheet2 will not be numerical then you could use

Excel Formula:
=INDEX(Sheet2!C:C,2)&""

If C2 could be numerical and you still want a number returned in Sheet1 rather than text then

Excel Formula:
=IF(INDEX(Sheet2!C:C,2)="","",INDEX(Sheet2!C:C,2))
 

JohnGreig

New Member
Joined
Feb 21, 2021
Messages
7
Office Version
  1. 2013
Platform
  1. Windows
Thanks Peter, all good now, you have been most helpful
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
You're welcome. Glad we could help. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,128,078
Messages
5,628,527
Members
416,323
Latest member
65563

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top