Reference a referenced cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sheet1!C4 contains the formula =Sheet2!A1

I want Sheet1!D4 to find out what cell Sheet1!C4 is referencing and then return the value two columns over. (Offset will take care of returning the value two columns over). My problem is I need to know which cell Sheet1!C$ is referencing. If I use the formula "=OFFSET(Sheet1!C4,0,1)" I get the value from one column to the right of Sheet1!C4, I need the value of one column to the right of the cell being referenced by Sheet1!C4, (Sheet2!A1) How would I do this.?
 
Hi
if you have unique values in column A of your first sheet try
=VLOOKUP('sheet1'!C4,'sheet2'!$A$1:$C$100,3,0)
 
Back
Top