if statement with #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need help to write a formula in excel. I want to use vookup to look up a
value in another worksheet, if vlookup does not find anything, I want to
write "false", otherwise is "false"
thanks a lot,
Minh
 
Maybe something along these lines....

=IF(ISNA(YourLookupFormula),"False",YourLookupFormula)

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not sure whether to use VLOOKUP or an IF statement 2
#N/A result because data is on another worksheet 8
How do I copy a VLOOKUP into a column and keep a constant array? 3
Help with IF and VLookup Match Statement 1
Vlookup and If statement help 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Vlookups to return a N/A value 3
Return 0 when if statement with VLOOKUP returns#N/A 3

Back
Top