I have a formula that should work like this:

IF data in C11 = "Cingular" then lookup data in A11 & give me the cingular
number
IF data = "Nextel" then lookup A11 & give me the nextel number
IF data = "Aircard" then lookup A11 & give me the aircard number
Otherwise, leave the field blank

Here's the formula:
=IF(C11="Cingular",VLOOKUP(A11,Sheet1!$A$2:$G$23,7 ,FALSE),
IF(C11="Nextel",VLOOKUP(A11,Sheet1!$A$2:$G$32,6,FA LSE),
IF(C11="Aircard",VLOOKUP(A11,Sheet1!$A$2:$G$32,8,F ALSE)," ")))

It works for the first two criteria, but I never get the aircard number;
instead I get a #REF! error whenever Aircard is in C11. It even gives me
blank when there's no criteria, which is good.

How can I modify the formula to get all the if statements to work? Any help
is appreciated.
--
Thanks, Karen