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