Vlookup Problem - need to return '0'

[gilbert]

Hi Excel experts,

Just wonder can we request Excel to return '0' instead of "#N/A" when
the database to lookup not found? To illustrate better, pls refer to
the enclosed example worksheet.

Attachment filename: test(1).xls
Download attachment: http://www.excelforum.com/attachment.php?postid=413313

 

[Arvi Laanemets]

Hi

=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))

 

[gilbert]

Gee...Arvi Laanemets, Thanks a zillion! Now I am starting to appreciate
this forum....it helps me to learn Excel faster with all the active
members help.