how to make the N/A not show in the below formula

  • Thread starter Thread starter Edson Peacock
  • Start date Start date
E

Edson Peacock

=VLOOKUP(LEFT(E5,4),DayRTM,2,0)&IF(LEN(E5)>4,"/
"&VLOOKUP(RIGHT(E5,4),DayRTM,2,0),"")



Hi all,

I have came to a standstill on how to make the above formula make the N/A
not show up. Any help is appreciated.


Thanks in advance,

Edson Peacock
 
Perhaps:
=IF(OR(ISNA(VLOOKUP(LEFT(E5,4),DayRTM,2,0)),ISNA(VLOOKUP(RIGHT(E5,4),DayRTM,2,0))),"",VLOOKUP(LEFT(E5,4),DayRTM,2,0)&IF(LEN(E5)>4,"/"&VLOOKUP(RIGHT(E5,4),DayRTM,2,0),""))
 

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

VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to i 1
Vlookup help on pulling more that one value. Any help is appreciated. thanks in advance 5
Vlookup Formula Limit Error ? (Reposting) 3
Yet Another #N/A Dilemma - Help 14
How to get a blank cell instead of a "0" 2
Searching the formula (not the value) for a text string 1
How can I make the box remain empty instead of N/A# 2
Help with N/A in formulas 3

Back
Top