August 22, 2010

not showing #N/A

product code key in
=IF(ISNA(OFFSET(DescriptionStart;MATCH(B23;ProdutColumn;0)-1;1;COUNTIF(ProductColumn;B23);1));"";OFFSET(DescriptionStart;MATCH(B23;ProductColumn;0)-1;1;COUNTIF(ProductColumn;B23);1))

to let the price hidthe #N/A
=IF(ISNA(VLOOKUP(B24;$Sheet2.A8:C345;3;0));"";VLOOKUP(B24;$Sheet2.A8:C345;3;0))

Today's Visitors: 0 Total Visitors: 0
Personal Category: Uncategorized Articles Topic: learning / education / linguistic
[Trackback URL]

Post A Comment









Yes No



Please input the magic number:

( Prevent the annoy garbage messages )
( What if you cannot see the numbers? )
Please input the magic number

誰來收藏
Loading ...
unlog_NVPO 0