Hi

I think I would be inclined to create 3 named ranges.
InsertNameDefineNameTeamA Refers to TeamA!$A$4:$F$100
Repeat for TeaamB and TeamC

Then your formula simplifies to
=VLOOKUP(A96,INDIRECT(F96),3,0)

--
Regards

Roger Govier


"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.