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

  • Thread starter Thread starter Dilip
  • Start date Start date
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
 
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
 
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
 
Back
Top