I need help writing a formula that will use the data in the 'Search name' table column to reference the worksheet name and pull the data from cell $H$4 into the 'Cost' column. I will be adding hundreds of worksheets and need to be able to copy this formula. I understand how to reference one at a time by using "='49-22-0002'!$H$4", but I need it to be referencing what's in the 'Search name' column on the same row. Please help!!
I do not know if that's what you mean, but check: =INDIRECT(ADDRESS(4,8,3,1,$C3))
Hi electric415. Welcome to the forum.
Also tryFormula:
Please Login or Register to view this content.
Dave
Thank you so much! That worked like a charm. I appreciate the help and quick response, and I hope I can help someone else in the future on this forum as I learn more.
Dave, thank you for the welcome, and I appreciate the time you took to help out. I can't wait to do the same for others.
You are welcome and thank you for the feedback.
Glad to know you'd like to help. It's always welcome and it's the fastest way to learn as well.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Last edited by FlameRetired; 03-01-2018 at 11:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks