Vlookup help on pulling more that one value. Any help is appreciated. thanks in advance

[Edson Peacock]

=IF(ISNA(VLOOKUP(E5,DayRTM,2,FALSE)),"",(VLOOKUP(E5,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

 

[Edson Peacock]

Hi All,

I will send the file if that will help

thanks in advance

Edson Peacock

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

Hi All,

I will send the file if that will help

thanks in advance

Edson Peacock

 

[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

 

[L. Howard Kittle]

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]

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