Forum Discussion
Making a "If" function work with a sheet tab name?
IF function – nested formulas and avoiding pitfalls
Visit the Excel Function Bible website
Standard Disclaimer: These are links to non-Microsoft websites.
Hope I was able to help you with these links.
I know I don't know anything (Socrates)
I downloaded your recommendation, but cannot find what I am trying to do. Not sure if I am explaining correctly, so I made a sample workbook. See attached. Ultimately, I am trying to get the values in Cells C4 through C8 to populate in the corresponding "Adder" sheets cell C5, when you click the "Button #1". I tried INDIRECT Function, IF function, MATCH, VLOOK UP. Not sure if I did them wrong, or they are not the correct functions?
=INDIRECT('Summary Page'!B4:B8&" '!")
=IF(INDIRECT('Summary Page'!B4:B8&" '!"),'Summary Page'!C4:C8," ")
=IF(MATCH(" '!",'Summary Page'!B4:B8),'Summary Page'!C4:C8," ")
=VLOOKUP(" '!",'Summary Page'!B4:C8,2,0)
The Summary Page sheet in your sample workbook is empty apart from the button, and there is no code in the workbook...
Not sure how that happened... try this.
