Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with an exact match | Excel Discussion (Misc queries) | |||
VLookup - Not Exact Match | Excel Worksheet Functions | |||
Using Exact() with VLookup or Match | Excel Worksheet Functions | |||
Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
vlookup more than one exact match | Excel Worksheet Functions |