View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BONITA BONITA is offline
external usenet poster
 
Posts: 17
Default Lookup value in table

Need to determine column of the lookup value in a table.
Lookup value = 6/1/06

Table A B C
row 1 7/1/05 7/1/06 7/1/07
row 2 6/1/05 6/1/06 6/1/07
row 3 5/1/05 5/1/06 5/1/07

The answer should column 2.

Your help is greatly appreciated.


--
Bonita