WLMPilot,

Reading your discriptions of your table, and the other responses, I'm not
sure if what you are asking is feasible (keep in mind that I'm not an
expert, compared to these other guys.......my knowledge of XL is
intermediate+).

It would make things a WHOLE lot easier if you changed your lookup table
into 2 lookup tables: 1st table would be tail number and type of aircraft,
2nd table would be type of aircraft and all the stats that go with each
type.

Then in FltInfo!B13, you could lookup the type of aircraft from the tail
number using the first table, and then in FltInfo!B14:B... you could look up
aircraft type specs from FltInfo!B13 (aircraft type) using the 2nd table (if
that is what your goal is).

HTH,

Conan





"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