![]() ![]() Maybe that can't happen in your dataset, but just beware. Incidentally, this will still break if Q23 is not found in L nor P. Since the array for the index is a single column, you could drop the final ",1", although personally I like the clarity it provides that this is definitely pulling a value from the first column. ![]() This should make it easier to debug, and probably more efficient to calculate since it only does two matches and one index, rather than 2 and 2 (although index is pretty efficient). Two branches of J2-M172, J2a-M410 and J2b-M102 make a considerable part of Y chromosome gene Rahul Gangal advises clients from a range of. (I've added some extra spaces to make it slightly clearer). If that's right, then I would move the error trap to the MATCH function, rather than the INDEX, like so: If it's there, do an index from K based on that position, else do an index from K based on a match against L76:2044 (and trust that a match exists). If I understand the logic correctly, you want to: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |