View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cel

Gabbon,
I would say you need a table of 4 columns: First column a date and the
remaining three ones your current headings.
It seems to me you want is to select a date, and then to report the
value of the three sub-headings for the row of this date.

If I have understood you correctly, then the following formula will do:

=IF(VLOOKUP(date, $A:$D, MATCH(heading,
$A$1:$D$1,0))="","",VLOOKUP(date, $A:$D, MATCH(heading, $A$1:$D$1,0)))

Supply cell references for date and heading.

HTH
Kostis Vezerides