vlookup exact match

  • Thread starter Thread starter Jo
  • Start date Start date
J

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)
 
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.
 
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:
 
Back
Top