IF Function referencing IsNumber, Match, Left function on separate sheets

[Touch9713]

Outcome: I need to populate a "Y" for Yes or blank for no in Spreadsheet #2, Column D, if 9 numbers from a Left function from Spreadsheet #1, Column B equals the numbers in Spreadsheet #2, Column A.

Issue: I'm trying to use the following function - =IF(ISNUMBER(MATCH(A2,(LEFT(Journal_Control_Template!B$2:B$7,9)),0)),"Y","N"); I'm receiving the "N" but I'm receiving the "Y" value.

Example Issue:

Sheet 1:
Column A Column B
JUL-10 123456789BOOK
JUL-10 777555444RED
JUL-10 888444666BLUE


Sheet 2:
Column A Column B Column C Column D
123456789 JUL-10 BOOK Y
777555444 JUL-10 RED Y
999222333 JUL-10 ORANGE N
888444666 JUL-10 BLUE Y

Thank you for your help.

[daddylonglegs]

Firstly your formula is an "array formula" and therefore needs to be confirmed with CTRL+SHIFT+ENTER

LEFT always returns a text value so if A2 is a number that won't match - if A2 isn't text-formatted then you might need to adjust that in the formula, i.e.

=IF(ISNUMBER(MATCH(A2&"",LEFT(Journal_Control_Template!B$2:B$7,9),0)),"Y","N")

....but if the B2:B7 values are always number and text as per your example (not just numbers) then you could use COUNTIF with wildcards like this

=IF(COUNTIF(Journal_Control_Template!B$2:B$7,A2&"*"),"Y","N")

and that doesn't need "array entry"

[Touch9713]

Thank you so much... the 2nd Countif function worked.