How To Find "x" In A Column And Show "y" In Cell "z"

R

rcane

Example:

A1 = aircraft type
B1 = flight time
C1 = jet category

Is there a way to maintain a list somewhere in the book of aircraf
types that are of the jet variety so that when "A2" is checked agains
the list it knows whether or not it is in fact a "jet" and will ente
the time (which is in "B2") under the jet category ("C2"). Otherwis
it simply will ignore adding flight time to the "C" column?

Did I just confuse everyone? Thanks in advance.


thanks

r
 
J

JulieD

Hi

yep, i'm confused :) no, not really

in sheet 2 create a list of all the jets
(e.g. A3:A100)

then on the sheet with the formulas type the following into C2
=IF(ISNA(MATCH(A2,Sheet2!A3:A100,0)),"",B2)

Cheers
JulieD
 
Top