Reference a referenced cell

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

Frank Kabel

Hi
if you have unique values in column A of your first sheet try
=VLOOKUP('sheet1'!C4,'sheet2'!$A$1:$C$100,3,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a referenced cell 2
Fill & Drag to Right !! HELP ! 2
Offset to a referenced cell 2
keeping format of a referenced cell 4
SUMIF function and cell /sheet reference 3
MACRO COLUMNS, SKIP ROWS 6
Offset to a referenced cell 2
MACRO PASTE CELL to COLUMN, SKIP ROWS 1

Top