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

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

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