try this idea
=IF(OR(D4="a",D4="b",D4="c"),VLOOKUP(D4,D1:E3,2)," NotThere")

--
Don Guillett
SalesAid Software

"GD Raynor" <GD wrote in message
...
I need to do a function that will look for one of three criterion in a
cell,
if condition a,b, or c is met, then I need to lookup a person's name and
then
assign them to a team. So far I've tried the following formulae, but it
turns
up NA or TRUE.

=if(f96="teamA"),vlookup(a96,TeamA!$a$4:$f$100,3,f alse),
if(f96="teamB"),vlookup(a96,TeamB!$a$4:$f$100,3,fa lse),
if(f96="teamC"),vlookup(a96,TeamC!$a$4:$f$100,3,fa lse)

Please advise as I'm quite new to this. Regards.