LinkBack URL
About LinkBacks
Can I make a cell read as if with an OR?
I have a list of combinations and some of them can be expressed differently. Is there a way to add the variations to the same cell for VLOOKUP to read them? Heres my file Im referring to sheet two around O193
Can I make a cell read as if with an OR?
I have a list of combinations and some of them can be expressed differently. Is there a way to add the variations to the same cell for VLOOKUP to read them? Heres my file Im referring to sheet two around O193
Is this possable or could I create a formula that hides all the cells that are <0 than something else? Im not too sure on this one.
Hi there,
I had a look at the file you posted, but I am not sure what you are trying to achieve. Can you explain more clearly using an example?
J.
Hi
So if I want type one of the letter squences in say cell say A13 I'm going to use VLOOKUP in cell B13 to say the name of the sequence. Those are all found on the second sheet. Now on the second sheet you can see that Ive been making the combination variations.
ex: Ab pp AA = bA pp AA there the same value, genetically speaking so I want to put the variations in the cells next to names, so I dont have to copy and paste and pull down the list.
So basically you need an automated mechanism that takes the combination you entered eg bA pp AA and based on that code tries to find the corresponding description in the list in sheet 2.
If it cannot find a matching description instead code Ab pp AA is used to lookup the description. Until it finds the matching description (listed with one of the genetical synonyms)
So when AA AA AA is entered, this is the only synonym there is.
but when Ab Ap Ae is entered, there would be 8 synonyms.
This means that ideally you would need 1 lookup and in the worse case you would need 8 lookups before you find the description.
the easiest way in my opinion is to write an custom lookup function (macro) that works the same as VLookup, but if it cannot find the description it tries another combination and keeps on doing that until all combinations are tried, or a description is found. So the function itself generates the next combination.
This way you only need to record one code per description
Would you like me to write the function for you? or can you do that yourself?
Last edited by jevni1974; 01-27-2008 at 05:29 PM.
I have no Idea hw to do that.. Im going to be applying this to a much larger range. Though if you make me on I can play with it and apply it. I just learned today the the $ sign means allways. Thanks in advance bro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks