VLOOKUP is looking for G7 in only column A (as this is the nature of how
VLOOKUP works). Your COUNTIF is looking at all 3 columns, A:C. So, if G7 is
found in C6, your first formula is true, but it causes an error in the
VLOOKUP. A better check would be to limit your COUNTIF to just A:A.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"pol" wrote:

I given the following formula

IF(COUNTIF([item.xls]sheet1!A:C,G7),TRUE,FALSE) , the result is showing as
true if the record exist in item.xls . At the same time I wrote another
VLOOKUP(G7,[item.xls]sheet1!A:C,3,0) the result is showing as '#NA' for the
same record which already showed as true in Countif .

Please anybody can help me to get the reason for the diffrent result in
both function;.