=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet called
"list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that can
have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29, I-32)
& get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is very
much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that would
need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock

Hi All,

I will send the file if that will help

thanks in advance

Edson Peacock
"Edson Peacock" wrote in message
news:GEUfh.269141$FQ1.101801@attbi_s71...
=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet
called "list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that can
have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29,
I-32) & get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is
very much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that
would need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock

Are there 2 separate lists for 1 to 29 and 1 to 32, like DayRTM and DayRTM2,
with different locations?

Possibility of having double lookups?
10 - 10
3 - 3

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Edson Peacock" wrote in message
news:Z9Vfh.313948$1i1.211236@attbi_s72...
Hi All,

I will send the file if that will help

thanks in advance

Edson Peacock
"Edson Peacock" wrote in message
news:GEUfh.269141$FQ1.101801@attbi_s71...
=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet
called "list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that can
have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29,
I-32) & get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is
very much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that
would need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock

All:

There is one list that has all the personnel in it. I would like to be
able to pull 2 different people from the same list. I want to be able to
put "I-29" in E5 and have F5 value be "Peacock, E.", but also be able to put
"I-29/I-32" in E5 and have F5 value be "Peacock, E./Bruce, J."


I-25 O'Connor, J.
I-26 Powers, G.
I-27 Kinser, C.
I-28 Malone, D.
I-29 Peacock, E. This list is dayRTM
I-30 Carrier, P.
I-31 Johnson, K.
I-32 Bruce, J.
I-33 Pierce, J.
I-37 Chinski, D.

Hope this helps with you understanding what I would like to get done.


Thanks again

Edson Peacock

"RagDyeR" wrote in message
...
Are there 2 separate lists for 1 to 29 and 1 to 32, like DayRTM and
DayRTM2,
with different locations?

Possibility of having double lookups?
10 - 10
3 - 3

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Edson Peacock" wrote in message
news:Z9Vfh.313948$1i1.211236@attbi_s72...
Hi All,

I will send the file if that will help

thanks in advance

Edson Peacock
"Edson Peacock" wrote in message
news:GEUfh.269141$FQ1.101801@attbi_s71...
=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet
called "list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that
can
have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29,
I-32) & get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is
very much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that
would need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock

Hi Edson,

Try this.

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

Where E5 has either:
I-29
I-29/I-25

HTH
Regards
Howard

"Edson Peacock" wrote in message
news:GEUfh.269141$FQ1.101801@attbi_s71...
=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet
called "list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that can
have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29,
I-32) & get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is
very much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that
would need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock

Hi Howard,

Thanks for help so far. =VLOOKUP(LEFT(E5,4),DayRTM,2,0)&IF(LEN(E5)4,"/
"&VLOOKUP(RIGHT(E5,4),DayRTM,2,0),"")
This formula works great. I have tried to make the #N/A go away and am
getting no where I cannot figure out the formula sequence to utilize the
=IF(ISNA(VLOOKUP...........),"",(VLOOKUP.......... .....))



Here is what I have come up with.



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



I cannot figure out what I have wrong excel won't accept it



Thanks

Edson Peacock





"L. Howard Kittle" wrote in message
...
Hi Edson,

Try this.

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

Where E5 has either:
I-29
I-29/I-25

HTH
Regards
Howard

"Edson Peacock" wrote in message
news:GEUfh.269141$FQ1.101801@attbi_s71...
=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E 5,DayRTM,2,FALSE)))

Hello all,

I am building a schedule workbook for post rotation. I have a sheet
called "list" This

sheet has all the Response Team Members "RTM" and their call sign (e.g..
I-29). I have a

sheet that dictates the post rotation automatic, but have a field that
can have a

replacement manual. This is were the formula comes in, the formula is
stored in F5:F28 this

formula looks up the value in E5:E28 and picks the name from the "list
sheet". The E5 value

is "I-29" and the F5 value is the lookup which is "Peacock, E.".

Up to this point everything works great.

I have the need to put two call signs in the cells E5:E28 (e.g.. I-29,
I-32) & get the lookup

to pull "Peacock, E. / Bruce, J.". When I do this it pulls nothing. I
don't know if this can

be accomplished. If you have any ideas please let me know, any help is
very much

appreciated.

I know that I can restructure the whole book and add another cell between
E5:E28 and the

F5:F28 if there is a need to have 2 individuals in the lookup. This will
require much of

restructure. I have 4 schedule programs that all have 18 sheets that
would need updated

with this formula and additional cell.

Thanks in advance for your help.


Edson Peacock