Thread: Update a cell with a specific value related to a date.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Update a cell with a specific value related to a date.
Jeff,
I assume your date and contributor lookup values are in K1 and L1
respectively. I further assume that your table occupies the range
A2:F10 and that date headings appear in row 2 as you indicate in your
post. Change as necessary.

=VLOOKUP(L1, A2:F10, MATCH(K1, A2:F2, 0), 0)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote