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.
 
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)
 
Upvote 0

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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"
 
Upvote 0
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))
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,317
Members
448,564
Latest member
ED38

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
Back
Top