Well, this might be a better code for you, 1 less VLOOKUP, and no ISNA
function...

=IF(COUNTIF('General Expenses'!$B$6:$B$8,AO3)=0,0,VLOOKUP(AO3,'General
Expenses'!$B$6:$C$8,2,FALSE))

Hope this helps.

--
John C


"Jo" wrote:

Hi there,

I want to use the vlookup function to return an exact match...can anyone see =(ISNA(VLOOKUP(AO3,'General
Expenses'!$B$6:$C$8,2,FALSE),0,VLOOKUP(AO3,'Genera l
Expenses'!$B$6:$C$8,2,FALSE)
where I'm going wrong with this forumla:



--
Jo :)