Nested VLOOKUP within IF Statement

[Sbrotz]

Trying to accomplish several things:

If L6 is blank, then L7 is blank.
If Vlookup does not find L6(Shasta Arabians) in the range "BusName",
blank ("") is returned rather than #N/A
If Vlookup does find L6(Shasta Arabians) in the range "BusName", th
fifth column value is returned.

My formula is as follows:

=IF($L6="","",IF(VLOOKUP($L6,BusName,5)=#N/A,"",VLOOKUP($L6,BusName,5,FALSE)))

where L6 = Shasta Arabians

Shasta Arabians is not in the Range "BusName" and #N/A is continuall
returned.

Ideas??
:confused

 

[Peo Sjoblom]

One Way

=IF(L6="","",IF(ISNA(MATCH(L6,INDEX(BusName,,1),0)),"",VLOOKUP(L6,BusName,5,0)))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)