Re: Update a cell with a specific value related to a date.
- From: "John Michl" <waxwing1@xxxxxxxxx>
- Date: 8 Dec 2005 09:53:36 -0800
Assume dates are entered in B1:F1 and individuals in A2:A10 so that the
work remaining is in B2:F10. If X and Y are the values you want to
find:
= INDEX(MATCH(Y,A2:A10,0),MATCH(X,B1:F1,0))
MATCH finds the position of each value in each ray (0 means match
exactly, see help for other options)
INDEX finds the intersection of the two positions.
Hope that helps
- John
www.JohnMichl.com
.
- Prev by Date: Re: Each New Excel to open in another session
- Next by Date: Re: Update a cell with a specific value related to a date.
- Previous by thread: Re: Each New Excel to open in another session
- Next by thread: Re: Update a cell with a specific value related to a date.
- Index(es):
Relevant Pages
|
Loading
