If in this, then do that (maybe)?

[kah5683]

Putting together to do list in excel. I am then prioritizing and putting items in daily calendar in same spreadsheet to print for day. I want to be able to scan a column, see a 1 I put in one row as the first priority item to do, and then upon seeing that one, copy the "to do" which is in a different column under same row, into another cell elsewhere on the spreadsheet. Seems simple enough, but after researching a while, not coming quick enough.

Example:

call Joe 3
pick up kids 1
balance checking 2

For a cell elsewhere on the spreadsheet where I am listing the times of day in the column before, I want that cell formula to scan the column of numbers, and when it sees number 1, take the value in first column "pick up kids" and copy into the cell next to the time.

Hopefully, this makes sense. I know I could just copy and paste, but would like this to work.

Edit: I see on final posting, numbers don't line up in a column like I see when I compose.

Thanks!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[kah5683]

I hope this is correct on attaching...

[AliGW]

I don't really get the logic. How is Excel meant to know at what time each of the tasks should be scheduled and why is there a gap between the first and second scheduled tasks? Where has Excel been told to leave a gap?

[AliGW]

Of course, I'm probably overthinking this!

Try this in L5 copied down:

=IFNA(INDEX($A$5:$A$10,MATCH(K5,$C$5:$C$10,0)),"")

[biex]

on my sample file...

on cell E1

=VLOOKUP(D1,CHOOSE({1,2},B:B,A:A),2,0)

Look for number 1, on B column and return value on A column

[biex]

base on your file

at cell L5

=IF(K5="","",VLOOKUP(K5,CHOOSE({1,2},C:C,A:A),2,0))