Hi,

Am Thu, 16 May 2013 09:13:36 +0100 schrieb J HART:

For example if I got a report for the following:

Dogs - 1
Cats - 3
Birds - 0

animals in sheet Main and also in sheet Export in column A and the
quantity in column B.
Then in sheet Export B1:
=IFERROR(VLOOKUP(A1,Main!$A$1:$B$3,2,0),0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2