Have a look at Excel help for the LOOKUP series of functions.
--
David Biddulph

"Tammy" wrote in message
...
Driller & CSI -

I another function too please. I'm sorry I ddin't mention before. I
didn't
see it til now.

I need
if Column A contains DFW and F 0, then I need G to = Bob
if column A contains AUS and F 0, then I need G to = Lynette
so on so on so on.

Thanks,
Tammy