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