Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ISERROR OR ISNA with VLOOKUP

Status
Not open for further replies.
JustATheory

JustATheory

IS-IT--Management
Feb 27, 2003
115
US
Greetings,

I'm attempting to use either ISERROR or ISNA with VLOOKUP to lookup data and replace the #N/A with some charchter in the same cell, but if it tests false report the original VLOOKUP formula in that cell. What's happening is in my formula, I receive an error when I have the charachter I'd like to show in the formula.

Thanks in advance,

Andy
 
Sort by date Sort by votes
forum68 is more appropriate for formula questions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

foxup
  • Locked
  • Question
CDO TLS or SSL
Replies
1
Views
537
foxup
foxup
Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
gussy81
  • Locked
  • Question
mail merge with attachments 2
2
Replies
20
Views
993
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
How to detect dups and/or sum by group?
Replies
1
Views
355
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Detect if Ribbon Minimized or Maximized 1
Replies
2
Views
647
TheAceMan1
TheAceMan1

Part and Inventory Search

Sponsor

Back
Top