Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup formula question
For the formula below,
=IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes ") What is "ISNA" and what does each value separated with comma represent? Thanks in advance! -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Hi Janice
not meaning to be unhelpful here, but you should check Help out for a good explaination of both of these questions. Depending on your version - ISNA is probably listed under a page called IS FUNCTIONS and VLOOKUP should come up if you type it into the paperclip (office assistant) or the ask a question box. Alternatively using the Paste Function Wizard (fx on the toolbar) will get you there as well. Cheers JulieD "Janice via OfficeKB.com" wrote in message ... For the formula below, =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes ") What is "ISNA" and what does each value separated with comma represent? Thanks in advance! -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
Do you understand what an IF function is?
Do you understand what the Vlookup function is? "no" and "yes" are string constants and one or the other will be the result displayed, either no or yes depending on whether the value in A1 is found in the column A of sheet2. Note that match would be the better choice here since vlookup is designed for a table and match is designed for a single column. when vlookup or match do not find the value being search for in the search range, they return the value #N/A with that, Julie D's advice should get you there. -- Regards, Tom Ogilvy "Janice via OfficeKB.com" wrote in message ... For the formula below, =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes ") What is "ISNA" and what does each value separated with comma represent? Thanks in advance! -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
formula question | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |