Hey - unless I'm not understanding you correctly this will work as expected;
=VLOOKUP({cell with value I am checking for},{the data range with headers and labels to check in}, ,MATCH({second conditional to search by row for},{the range to apply the search with no headers or labels},0)+1,FALSE)
It will preform what is called a two way look-up; you can achieve this with any number of lines or worksheets to make more complex conditionals, you can assign this to a LET variable function as well if needed in some but not all situations and apply IF AND NOT TRUE FALSE Logic from there - Hope this help, if unclear, look up "2-way look-up excel on google"
