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

vlookup exact match
 

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

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