Need a help display 0 value

[pol]

I used the following formula
=IF(COUNTIF([item.xls]sheet1!B:B,G7),VLOOKUP(G7,[item.xls]sheet1!B:L,11,0),0
IF(ISNA(VLOOKUP(G9,[item.xls]Sheet1!B:L,11,0)),0,VLOOKUP(G9,[item.xls]Sheet1!B:L,11,0))

If there is no match in the record in Item.xls with G7 column, the result
value should be displayed as 0. But the current column is showed as null
when there is mismatches. But 0 value is there on that column but it is not
visible. Please have you any suggesion to solve this problem.

With thanks
Pol

 

[Atishoo]

Tool - options - View tab - check the "zero values" box

 

[Dave Peterson]

First, it's best to copy|paste the exact formula from the excel worksheet than
to retype it.

If your formula actually works, then I'd look for another match higher (lower
numbered row) in sheet1 in the item.xls workbook. Maybe there's a match that
has a corresponding value of ="" (an empty string).

I used the following formula
=IF(COUNTIF([item.xls]sheet1!B:B,G7),VLOOKUP(G7,[item.xls]sheet1!B:L,11,0),0)
IF(ISNA(VLOOKUP(G9,[item.xls]Sheet1!B:L,11,0)),0,VLOOKUP(G9,[item.xls]Sheet1!B:L,11,0))

If there is no match in the record in Item.xls with G7 column, the result
value should be displayed as 0. But the current column is showed as null
when there is mismatches. But 0 value is there on that column but it is not
visible. Please have you any suggesion to solve this problem.

With thanks
Pol