Another nesting issue

E

Ed Davis

Does anyone know how I can get information from a range of cells more than
nine rows?
Example
If a name shows up within a range from range D9 through D20 then enter
whatever
is in the cell in column F but the same row as the name shows up on?
 
D

Don Guillett

Look in the help index for MATCH. Then look for INDEX and nest your match
within the index.
 
E

Ed Davis

OK I figured it out but I now have another problem.
This is the formula I am using.

=INDEX(C$6:F$14,MATCH(C34,$C$6:$C$14,0),3)

However, if the name in c34 does not exist it gives me the following:
#N/A

Is there a way to not get the N/A message?


Thanks in advance.
 
P

Pete_UK

Try this:

=IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$14,MATCH(C34,$C$6:$C
$14,0),3))

Gives you a blank cell instead - you could change the "" to "warning"
or some-such.

Hope this helps.

Pete
 
E

Ed Davis

That did it.
Thank you very much.


Try this:

=IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$14,MATCH(C34,$C$6:$C
$14,0),3))

Gives you a blank cell instead - you could change the "" to "warning"
or some-such.

Hope this helps.

Pete
 
Top