Another nesting issue
 

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?

Another nesting issue
 

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?

Another nesting issue
 

Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
Look in the help index for MATCH. Then look for INDEX and nest your match
within the index.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?

Another nesting issue
 

Are you saying that you don't know how to use Excel help?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
Look in the help index for MATCH. Then look for INDEX and nest your match
within the index.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?

Another nesting issue
 

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.


"Don Guillett" wrote in message
...
Are you saying that you don't know how to use Excel help?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
Look in the help index for MATCH. Then look for INDEX and nest your
match within the index.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?

Another nesting issue
 

Try this:

=IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$1 4,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

On Sep 2, 4:47*pm, "Ed Davis" wrote:
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.

"Don Guillett" wrote in message

...



Are you saying that you don't know how to use Excel help?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
Look in the help index for MATCH. Then look for INDEX and nest your
match within the index.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?- Hide quoted text -

- Show quoted text -

Another nesting issue
 

That did it.
Thank you very much.


"Pete_UK" wrote in message
...
Try this:

=IF(ISNA(MATCH(C34,$C$6:$C$14,0)),"",INDEX(C$6:F$1 4,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

On Sep 2, 4:47 pm, "Ed Davis" wrote:
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.

"Don Guillett" wrote in message

...



Are you saying that you don't know how to use Excel help?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
Look in the help index for MATCH. Then look for INDEX and nest your
match within the index.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?-
Hide quoted text -

- Show quoted text -

Another nesting issue
 

You're welcome, Ed - thanks for feeding back.

Pete

On Sep 2, 7:50*pm, "Ed Davis" wrote:
That did it.
Thank you very much.