View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default vlookup exact match


try

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


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



"Jo" escreveu:

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,'Genera l
Expenses'!$B$6:$C$8,2,FALSE)

--
Jo :)