Hi!
I'm not sure if it's even possible, but I give it a try here. Is there a way of using a "searching-rule" to change the content of specifics cells that meets the requirements of that rule?
For example, I want to add the value of "1" in the cells of the column B, for which their row contains a "1" in the column A. So in this table, the cell B1, B2 and B5 would inherit the value of "1". Naturally, this is to be used on a much larger table.. Thanks!
A B 1 1 2 1 3 2 4 3 5 1 6 2
Last edited by machenier; 09-24-2014 at 11:57 PM.
Hi, welcome to the forum
If I understand you correctly...
=if(A1=1,1,"")
copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you want multiple value, can do like this
=LOOKUP(A1,{1;2;3;4;5},{1;2;3;4;5})
OR return string
=LOOKUP(A1,{1;2;3;4;5},{"a";"b";"c";"d";"e"})
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Thanks a lot FDibbins! Didn't thought it would've been that easy, still have a lot to learn with Excel haha Works like a charm!
you'r welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks