Excel Help needed!

Molanole

Hi everyone

Now I know this is not particularly money saving but I figured that one of you knowledgable people would probably know the answer to this.

I'm trying to set up a database in excel and I want to know if there is a way to autocomplete specific information in adjacent cells based on the information I put in the first cell.

E.g. Let's say I'm inputting some activities:

football, it starts on a monday and lasts for 3 days
cricket, tuesday, 2 days
basketball, wednesday, 4 days

where A1 would be "football", B1 would be "Monday" and C1 would be "3"

What I'm trying to find out (as there'll be loads of records) is whether there is a way that Excel will automatically complete cells B1 and C1 with the right information just by me typing the entry (i.e. football, cricket etc) into A1 to save me having to manually input all of the info each time.

Confused?? I am!!

If anyone can help me, or point me in the right direction, that would be really great. I've tried using the help function and searching on google but I never get the right results!

Thanks so much if you've got this far.

Mola x

TotallyBroke

I think you can set up some conditioning rules. Look in Format, Conditioning formatting. You can then say if cell values is equal to football then this cell is equal to blah blah.

fwor

Excel is so flexible that there are probably a dozen ways to do that!

But I would do it by creating a table (hidden out of sight) which comprises one entry for each activity, the "normal" starting day in the next column and the "normal" number of days for that activity in the third.

You can then use the VLOOKUP function to find the activity name, and use an offset of 1 to return start day, and an offset of 2 for the number of days.

chrwil

Or you could use a formula. Type up in excel for example in cell A1 to C3
Football Monday 3
Cricket Tuesday 2
Baseball Wednesday 4

Then start putting in the activity. Say you start putting in the activity in H1, use this formula in cell I1 =VLOOKUP(H1,A:C,2,FALSE) and in cell J1 put =VLOOKUP(H1,A:C,3,FALSE)

This should work.

Molanole

:T Brilliant! Well done everyone. I knew you'd know the answers. :T

Thanks again

Mola