Formula to update a cell from the information on a different worksheet.

Kaharthemad

New member
Joined
Feb 28, 2012
Messages
2
Reaction score
0
Points
0
I am dealing with multiple worksheets (about 15) there is data that spans all of the worksheets.

At present I have the pages set with a relationship so that A2 on worksheet 'survey' pulls the name of a facility from the 'location' worksheet column c using a drop down box.

I would like to be able to centralize the information from one cell on worksheet 'Site' to 'location information'.

I need the data to be available on one sheets, and when it is available on one sheet is updates the other. Any change to Survey 'A23' will make changes to the cell.


I have this formula right now to tie the cells together with the facility. is there a way to change this code to allow this?
Code:
=INDEX('Locations'!AJ:AJ,MATCH(A2,'Locations'!C:C,0))
 
Back
Top