I have the following problem and don't know if I need to find a different
function or what.

FltInfo!B12 = N48967 (the tail number of aircraft to be flown)
FltInfo!B13 = formula to find type aircraft on another worksheet based on B12.

You can have multiple tail numbers per type airplane.
Ex: Tail Numbers N48967, N12345, N23456, etc, could all be a Cessna 172XP
type.

The airplane performace specs (worksheet = Airplanes) w/ the associated tail
numbers are entered in columns C:G (for example) So specs and tail numbers
for a Cessna 172XP are in column C, with C40:C43 being the tail numbers. The
range for ALL tail numbers are C40:J43 and the type airplane is in C1:J1

I want to locate the tail number (based on FltInfo!B12) within the range
Airplanes!C40:J43 and return the value within range Airplanes!C1:J1 (type
airplane)

Thanks for you help!
Les