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

=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

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

Perhaps:
=IF(OR(ISNA(VLOOKUP(LEFT(E5,4),DayRTM,2,0)),ISNA(V LOOKUP(RIGHT(E5,4),DayRTM,2,0))),"",VLOOKUP(LEFT(E 5,4),DayRTM,2,0)&IF(LEN(E5)4,"/"&VLOOKUP(RIGHT(E5,4),DayRTM,2,0),""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Edson Peacock" wrote:
=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

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

Max,


You are a genius. Thanks alot

Edson Peacock
"Max" wrote in message
...
Perhaps:
=IF(OR(ISNA(VLOOKUP(LEFT(E5,4),DayRTM,2,0)),ISNA(V LOOKUP(RIGHT(E5,4),DayRTM,2,0))),"",VLOOKUP(LEFT(E 5,4),DayRTM,2,0)&IF(LEN(E5)4,"/"&VLOOKUP(RIGHT(E5,4),DayRTM,2,0),""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Edson Peacock" wrote:
=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

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

Glad it worked ok for you !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Edson Peacock" wrote in message
news:9c2gh.1096217$084.716721@attbi_s22...
Max,
You are a genius. Thanks a lot
Edson Peacock