Sounds to me like an INDEX and MATCH together, but I'm having trouble
visualizing the sheet.
The formula below goes in a table from C12 to H17 and returns the value at
the intersection of columns D ~ H and rows 13 through 17

=INDEX(C12:H17,MATCH(N3,C12:C17,0),MATCH(N9,C12:H1 2,0))

HTH

"WLMPilot" wrote in message
...
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