How do I include names in formula by picking up names from rows

D

Dilip

I have created an excel formula with names in it.
I have created a set of names and I want to call the names given in the row
through formula.
3 A B C D
4 123 4/12/09 4/16/09 HOLDAY1
=IF(AND(A4<>"",(NETWORKDAYS(B4,C4,D4))>2),NETWORKDAYS(B4,C4,D4))
here HOLIDAY1 is one among the list of holdays listed in a separate column.
When I use the row number in the formula, it is not considering my name value.

Is there way to include or call name through formula
 
J

Jacob Skaria

Dilip

Suppose you have the list of holidays in G1:G10 refer the range in formul as
below

=IF(AND(A4<>"",(NETWORKDAYS(B4,C4,G1:G10))>2),NETWORKDAYS(B4,C4,G1:G10))

If you have named the range G1:G10 as holiday1 refer that as below

=IF(AND(A4<>"",(NETWORKDAYS(B4,C4,holiday1))>2),NETWORKDAYS(B4,C4,holiday1))

If this post helps click Yes
 
D

Dilip

Hi Jacob,
Thanks for your suggestion, but my intention is to use names listed
(holiday) in a row and call those into my formula and drag the formula to the
entire column.
Actually indirect was working fine
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top