How do I reference a row in another sheet in the same workbook?
How do I reference a row in another sheet in the same workbook?
Depends exactly what you mean by reference a row. If you mean find the value of a cell in that row then use something like:Originally Posted by YellowJeep
If you mean you want to use the row in say a MATCH() function, then simlarly:Please Login or Register to view this content.
HTHPlease Login or Register to view this content.
Thank you! And if other newbies want to know ='sheet name'!C3 can be used if the tab name has been renamed.
Well, I hoped that I'd be able to figure the rest out on my own but it's not happening.
How would I say...
If any cell in Sheet2 $E$4:$E$50 = "Yes" then "Yes".
Excel 2007
Hi,
=RgdsPlease Login or Register to view this content.
That's returning 'Yes' if there is any text at all in that range. ?
Sorry, I'd misunderstood the question. Try:Originally Posted by YellowJeep
RgdsPlease Login or Register to view this content.
No problem, I don't mind extra nuggets of knowledge! BTW the full answer to my question I was after is...
=IF(COUNTIF('Sheet Name'!$E$4:$E$50,"Yes")>=1,"Yes","No")
Thank you for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks