Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with ISNA and VLOOKUP
accidentally posted this in General Need help with a formula.. Let's say I have "12/31/2000" in Sheet 1, Cell A1 and I need to see if this date is in a table in Sheet 2 and if it is it will return a value of "1" and if not it returns a value of "2" The formula I have is =IF(ISNA(VLOOKUP(A1,Sheet2!A1:B4,2)),0,1) 12/31/2000 is NOT located in Sheet 2 yet I still get a return value of 1.. help would be appreciated -- webstju ------------------------------------------------------------------------ webstju's Profile: http://www.excelforum.com/member.php...o&userid=33703 View this thread: http://www.excelforum.com/showthread...hreadid=536447 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problem with ISNA and VLOOKUP
It is doing an approximate match. Use
=IF(ISNA(VLOOKUP(A1,Sheet2!A1:B4,2,FALSE)),0,1) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "webstju" wrote in message ... accidentally posted this in General Need help with a formula.. Let's say I have "12/31/2000" in Sheet 1, Cell A1 and I need to see if this date is in a table in Sheet 2 and if it is it will return a value of "1" and if not it returns a value of "2" The formula I have is =IF(ISNA(VLOOKUP(A1,Sheet2!A1:B4,2)),0,1) 12/31/2000 is NOT located in Sheet 2 yet I still get a return value of 1.. help would be appreciated -- webstju ------------------------------------------------------------------------ webstju's Profile: http://www.excelforum.com/member.php...o&userid=33703 View this thread: http://www.excelforum.com/showthread...hreadid=536447 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort with ISNA and vlookup | Excel Worksheet Functions | |||
VLOOKUP and ISNA functions | Excel Worksheet Functions | |||
isna vlookup | Excel Discussion (Misc queries) | |||
ISNA and VLOOKUP | Excel Worksheet Functions | |||
if isna and vlookup together | Excel Worksheet Functions |