One more question: I used the INDIRECT function to refer to a single cell from another tab, = INDIR

Re: Nesting INDIRECT function
Try this formula: or this simplified:
One more question: I used the INDIRECT function to refer to a single cell from another tab, = INDIRECT ($ C $ 2 & "$ F1") but when I use the copy command to beneath what is "F1" cell in formula does not change to "F2". Is to fix it?
F1 is in cell F1 'Products'. If u want to change this value a possible solution would be: = INDIRECT ($ C $ 2 & "$ F" & ROW (A1 Produtos!)) If not that, you'll have to explain myself better oq you wanna do.
That's right. Only I'm trying to go to "Products" tab without referring to it as you put = INDIRECT ($ C $ 2 & "! $ F" & ROW (A1 Produtos!)). Did you use the same principle INDIRECT ($ C $ 2 "!) If $ C $ 2 would be the tab" Products. "Something like = INDIRECT progress book ($ C $ 2 &"! $ F "& ROW ($ C $ 2"! A1)) being the "A1" has to be free, without quotation marks, for when I pull or copy and paste this reference is changed to "A2", "A3", etc..
Good night Lecex I do not quite understand progress book what u want, but u pull it changes the formula is from A1 to A2, A3 .... mesnos would look like this: = INDIRECT ($ C $ 2 & "! $ F" & ROW ($ C $ 2 "! $ A" & ROW ())) Just putting progress book your example, not tested any formula. A hug.
Unfortunately gave error. What I want is: I have two tabs (Tab1 and Tab2), cause the value of "A1" in Tab2 equals progress book the value of "A1" from Tab1. Use the INDIRECT function in Tab2 "A1", to refer to Tab1 and not simply write = Guia1A1.
Very good Sunday! That was exactly what I wanted. Thank Display posts from previous: All posts 1 day 7 days 2 weeks 1 month 3 months 6 months 1 year Sort by Author Post time Subject Ascending Descending
Return to Excel Jump to: Select a forum ------------------ News INTERNET INFO Online Events Blogs Browsers Internet Explorer Firefox Opera Chrome SEO and SEM Search Email and Webmail Gmail online forums Google Shops Lodging MSN Instant Messaging Social Networks RSS Twitter Facebook Wikipedia Yahoo More SOFTWARE Microsoft Office Access Word Excel PowerPoint PDF OpenOffice Graphics Software Photoshop Sharing KaZaA P2P BitTorrent eMule More Security Firewall Malware AntiVirus Backup Encryption DEVELOPMENT More. COBOL CMS ASP NET Web Standards CSS HTML XML C / C + + / C # Delphi Flash and Silverlight Java JavaScript PHP Python Perl Ruby on Rails VBA Webdesign More SYSTEMS Microsoft Windows Vista Windows XP Windows 7 Windows Server MSDOS Windows 8 Android Ubuntu Linux Macintosh Symbian BSD More COMMUNICATION Broadband GSM and 3G Vírtua Speedy WiMAX VoIP WAP SMS GPS Maps More GAMES AND ENTERTAINMENT Wii PC PlayStation Xbox Music Photography Video DivX and Xvid & nbs