Hi folks, thanks for having me here, my first post after crawling around the internet and looking for answers. You seem the right people to save me!
So here's my situation: I'm running a fairly complex formula to search for AN ID (ID in COLUMN B) in an array (COLUMN G), and return the value of a different column (VALUE in COLUMN H) when found.
However, my formula is giving me a match for partial matches, not exact matches, as such:
If I search for 5.1, it's also returning results for 15.1, or 5.11.
Furthermore, I'd like the results to have a carriage return between them, but it doesn't seem to be working.
I thank you all in advance, and I'm keen to share the knowledge I have y'all.
Bookmarks