MrExcel Publishing
Your One Stop for Excel Tips & Solutions

linking 2 sheets

Posted by tim on December 15, 2001 5:52 PM

I am in dire need of some Excel help.

My situation:

I have created two sheets, which I will call sheet1
and sheet2. I want cell "sheet2!d11" to display the
value from "sheet1!A37" using the range
"sheet2!A11:C11" in place of range "sheet1!B4:B6"

I would be very greatful for any suggestions.


Posted by denis on December 16, 2001 8:22 AM

Unclear what u want tim, is it a lookup formula ?
i.e =vlookup(sheet1!A37,sheet2!A11:C11,3,0)