Help with a formula across multiple tabs of data
Hi there! I am trying (and failing) to write a formula that will fill in a column based on data within another tab of that same worksheet. I know it's probably super simple to do, I just can't get it to work.
First tab has transactions along with the category and a blank column that I want to fill in with the "new category".
The second tab has a list of all categories in Column A and what the "new category" should be in Column B.
Any help would be much appreciated. Thank you!
Formula for G2
Formula:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
AWESOME! Thank you SO very much, mehmetcik! It works perfectly! Have a great weekend. =)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks