Lookup help

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a spreadsheet with certain events listed down the
page and months listed across the page.

Each event will only happen in a specified month,
therefore each row will only have one checkmark (under
whatever month column is appropriate).

I have one inserted column (column B) next to the event
(column A) - I am trying to put a formula in this column B
that will check the entire row for a checkmark and return
the month that they checkmark was placed in. That way I
can just look at columns A and B and see the event and
when it will take place.

I tried putting checkmarks above the months going across
and tried a hlookup, but could never get it to work. Will
this work since the checkmark is not unique?

I know this has to be possible in Excel and would
appreciate any help so that I can learn how to do this.

Thanks!
-Steve
 
With your months in C1:N1, events in A2 down, and your checkmark being a "x", in
cell B2 put the following formula and copy down as far as you need - Format Col
B as dates also, assuming that C1:N1 were formatted as dates:-

=INDEX($C$1:$N$1,MATCH("x",$C2:$N2,0))

Change the checkmark for whatever you are using (Make sure it has quotes around
it).
 
That did it! Thanks Ken!

Never thought of using Index and Match together - very
interesting - going to have to study this one...

-Steve
 
Back
Top