please view attachment..
Not sure how to best describe it - so hopefully the diagram will help.
Hope you can help me.
please view attachment..
Not sure how to best describe it - so hopefully the diagram will help.
Hope you can help me.
Last edited by dearlove88; 04-30-2010 at 12:13 PM. Reason: Rules
Wellcome to the forum.
Please, rename your title according to the rules:
1. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.
Yes its possible but "what is an exact match in A1"
if(a1=e1,c1,"") if it is the whole cell contents
of if it is part of the cell
=IF(ISERROR(SEARCH(E1, A1, 1)),"",C1)
is this what you mean?
Regards
Dav
basically if the two match ( can be in any random order) it pulls the info from its associated cell and puts it in the other.
You'd do better posting an example in an Excel workbook but try this in C1 (for example)
=IF(ISNUMBER(MATCH(E1,A:A,0)),F1,"")
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
new attachment - hope it shines some light on it
Last edited by dearlove88; 04-26-2010 at 11:00 AM.
Okay, not exactly a spreadsheet but we'll work with it. So now it's not Columns A,E and F but Col I matches anything in Col G, then you want Col J moved into Col A? But Col A already has something in it? If that's true, then, without resorting to VBA, in a blank column
=IF(ISNUMBER(MATCH(I1,G:G,0)),J1,A1)
If there is a match for the value in I1 anywhere in G, then paste the value of J1. Otherwise paste the value from A1. Then you'd copy and paste Special >Values that column over to Column A. Is that what you are looking for?
If Col J matches anything in B then it takes the associated data from COL i and puts that into the matching row in COL G
Okay, we're getting there.....
Q1. If J2 matches B7, do you want J2 or J7 in Col G?
Q2. What if Col J doesn't match anything in B, what do you want in G?
Okay, I must be having a slow week. I get the first part. If what's in B8 matches J9, put what's in I9 into G8.
Let's say there is no match "if it's blank then it matches with anything from Column C" So does that mean, if there's no match in the first part, then try to match column C to Column J? and follow the same rule (If what's in C8 matches J0, put what's in I9 into G8)??
For the first part of your function (assuming everything matches) try this in G7 (first row)
=INDEX($I$7:$I$100,MATCH(B7,$J$7:$J$100,0)) Try that out and see if it delivers.
Yes the first part works!
So want to explain the second part to me again?
I think that's it? Confused myself now .... I'll try break it and get to you if I have any problems.
Actually sorry to throw a spanner in the works but would it be possible to move I,J Column table onto anoth tab and call data from that (call the tab "kwdata") - just make it a lot cleaner and will help if I expand it.
Last edited by dearlove88; 04-28-2010 at 05:06 AM.
Any update on this?
Thanks
BUMP.... Just need this last little bit resolving that would be fantastic!
Yes, you can move I and J to kwdata. The formula then becomesIs that what you are asking for?Please Login or Register to view this content.
perfect
Just one more request - sent private PM. Basically if cell is empty i want it to look in the next column on.
dearlove, PM is not for asking questions. Ask your questions in the thread, and use PMs only for messages outside of thread topics.
Ok, no worries.
If B is empty, you want to look in C
=IF(B7<>0,INDEX(kwdata!$I$7:$I$100,MATCH(B7,kwdata!$J$7:$J$100,0)),INDEX(kwdata!$I$7:$I$100,MATCH(C7,kwdata!$J$7:$J$100,0)))
Does that work for you?
Perfect thank so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks