Comparing Two workbooks

[AJ]

I am comparing two separate workbooks to find out if an order that had to be
reshiped was returned. within "2009 Reship Orders" spreadsheet I list the
original order number, within my 2009 Returns spreadsheet, I have all the
order #s of packages returned. I want to check the original orders from my
2009 Reship Orders spreadsheet against the order #s on my 2009 Returns
spreadsheet to see if the package was return, if so put YES in the column,
and leave blank if not.
This is the formula that I have in cell m310 of my 2009 Reship Orders

=IF(INDEX('[2009 Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,MATCH(I310,'[2009
Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,0))=I310,"YES","")

This gives me the yes when it does find a match, however instead of giving
me "" back when it is not found, I get #N/A.

Can someone tell me what I did wrong?

 

[joel]

You need to test if a match is found like this

if(ISNA(match(your match formula)),"",Index(your full index formula))

 

[AJ]

Thanks for the help, it worked, I get a true message if found which is fine.
Just curious is there a way for it to say yes instead of True?

You need to test if a match is found like this

if(ISNA(match(your match formula)),"",Index(your full index formula))

I am comparing two separate workbooks to find out if an order that had to be
reshiped was returned. within "2009 Reship Orders" spreadsheet I list the
original order number, within my 2009 Returns spreadsheet, I have all the
order #s of packages returned. I want to check the original orders from my
2009 Reship Orders spreadsheet against the order #s on my 2009 Returns
spreadsheet to see if the package was return, if so put YES in the column,
and leave blank if not.
This is the formula that I have in cell m310 of my 2009 Reship Orders

=IF(INDEX('[2009 Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,MATCH(I310,'[2009
Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,0))=I310,"YES","")

This gives me the yes when it does find a match, however instead of giving
me "" back when it is not found, I get #N/A.

Can someone tell me what I did wrong?

 

[AJ]

That worked thanks, get TRUE in the cell if found. Just curious, is there a
way for it to say Yes instead of True, not that important if not.

You need to test if a match is found like this

if(ISNA(match(your match formula)),"",Index(your full index formula))

I am comparing two separate workbooks to find out if an order that had to be
reshiped was returned. within "2009 Reship Orders" spreadsheet I list the
original order number, within my 2009 Returns spreadsheet, I have all the
order #s of packages returned. I want to check the original orders from my
2009 Reship Orders spreadsheet against the order #s on my 2009 Returns
spreadsheet to see if the package was return, if so put YES in the column,
and leave blank if not.
This is the formula that I have in cell m310 of my 2009 Reship Orders

=IF(INDEX('[2009 Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,MATCH(I310,'[2009
Returns spreadsheet.xlsx]Mar'!$H$6:$H$146,0))=I310,"YES","")

This gives me the yes when it does find a match, however instead of giving
me "" back when it is not found, I get #N/A.

Can someone tell me what I did wrong?