You guys are awesome and I have solved nearly all of my life's problems through this forum... but...
I have a problem where I need to have an output of a certain string of text if certain conditions are met. The below formula is what I have come up with so far but I keep getting a #VALUE! error.
=IF(AND(LEFT(B2,2)=MID(H3:H6,44,2),E2=MID(H3:H6,13,4)),H3:H6,FALSE)
So if certain characters within a string equal characters within another string in an array of strings, and if a certain cell matches the value of another part of that string of text in the array, create an output of that specific cell that matches both criteria. I assume that my problem is the equation is slightly too ambiguous. Please note that many of the values are duplicates (need to keep them).
Even an explanation of my issue would be a helpful first step in fixing this problem.
Thank you all!
-Ryan
Bookmarks