• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

formula to ge trid of N/A

What would be formula to get rid of #N/A and have cell blank if number isn't available? Book2.xlsx
0
Aselly22
Asked:
Aselly22
  • 2
  • 2
2 Solutions
 
SiddharthRoutCommented:
Use this formula

=IF(ISNA(A1),"",A1)

So if cell A1 has #N/A then it will show blank.

Sid
0
 
Aselly22Author Commented:
I should explain further. look in column F i have a vlookup. What i need to do is add to that vlookup that if the number is not available in array then return blank not #N/A
0
 
wchhCommented:
Another option:
=IF(ISERROR(VLOOKUP(E1,A$1:C$15,3,FALSE)), "", VLOOKUP(E1,A$1:C$15,3,FALSE))
0
 
SiddharthRoutCommented:
Ok Got it :)

Try this in Cell F1

=IFERROR(VLOOKUP(E1,A$1:C$15,3,FALSE),"")

Sid
0
 
Aselly22Author Commented:
TY
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now