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