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

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 :)