scan range and return value if adjacent cell = something

So I am not sure if this requires VBA or not. I wouldn't think a tool like excel would need it as I would think this is built in with index and match perhaps...but Idk for sure.

So basically, all I would like to do is return a range or cells contents if a value next to it equals something I define like TRUE / FALSE.

So if you look at my sample document attached, what I mean is that I would like to scan Column A and return any value in B, if column A has whatever I define (in this case TRUE / FALSE). So in this example, if true exists in column A, return column B as such.

Does this require vba and if so how?

Here you go:

Please Login or Register  to view this content.

Let me describe how it works.
it will compare the text in column A to the cells H7 and M7. if it matchs with one of them then it will return the corresponding value in the matching column starting from row 14. Just give it a try on the same file ytou attached. if you will change the values from TRUE & FALSE then you will have to change them as well in cells H7 & M7

Please open the attached file and run the macro without changing anything

And this will do the opposite
Sorry for my stupidity.

Please Login or Register  to view this content.