I would suggest a simpler approach... using a named range and moving the formula into the properties of the named range. Then just use the named range as your reference.
The formula for the picture becomes
Formula:
=ShownPicture
and the formula for the named range (ShownPicture) is
Formula:=INDIRECT("Sheet2!$A$"&VLOOKUP('TROUGH ROLLER'!$P$14,'TROUGH ROLLER'!$Q$14:$R$26,2,0))
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hello aboutsetta,
I have the same problem and your solution doesn't work in Excel 2011 for Mac. It gives me the error "Reference is not valid". Do you know how I could solve it?
Thanks in advance,
javier.vallaure
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
MaxOtis 
Register To Reply
Bookmarks