vlookup exact match

[Jo]

Hi there,

I want to use the vlookup function to return an exact match...can anyone see
where I'm going wrong with this forumla:

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

 

[John C]

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.

 

[Marcelo]

try

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


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jo" escreveu: