'foo'
and'bar'
text within the formula to use another cell reference. Anyhow, this should get you began at least.'club'
is only found once in columnN
After that you can use'club'
is usually never found in line W it will return#N/A
if you need to modify that you can wrap the entire point in anIFERROR
statement and return your 0.'ERR'
if there are usually nothing or several matches. If you consider to make use of it to appear up text message, it will return 0.=IF(AND(A1='foo',B1='boo'),'boo',0)
0
, or FALSE, parameter, it appears just for an precise match and given its nature, just the initial instance discovered) after that INDEX returns the value at that position within B:B.#D/A
result that would show up if you couldn't find a result due to it not really appearing in your search for listing.