Need help with searching and looking up.

[dontyoudare61]

I want to make a spreadsheet that will automatically show who is scheduled for which position on what day of the week.
I tried some kind of search function to check an entire column for keywords like "dish" and then return the cell in the adjacent column, but no luck.

Example of how a schedule would be set up

Monday	Tuesday	Wednesday
John	dish	off	off	off	off	off
Jill	off	dish	off	off	off	off
Ben	off	off	dish	off	off	off
Bob	off	off	off	dish	off	off
Ken	off	off	off	off	off	dish
Damon	off	off	off	off	off	off

Example of how I want it to search for who is in what position.

Monday
Dish:	John

Tuesday
Dish:	Jill

[oeldere]

Please Login or Register  to view this content.

and drag down.

See the attached file.

[micope21]

Hi

What happen if more than 1?

I done this if more than 1!

Please Login or Register  to view this content.

This is array formula! Press same time Ctrl+Shift+Enter, NOT ENTER!! Copy down and cross.

See the file!

Regard

[Vikas_Gautam]

Try this ...
Simply drag down..

Please Login or Register  to view this content.

Check the attachment..

dont' forget to click *

[sktneer]

I think you need a simple setup. See the attached.

[Vikas_Gautam]

Excellent application..
Sktneer...

[sktneer]

Thanks Vikas.
Let the OP decide whether this is helpful to him or not. He has so many options now.

[Vikas_Gautam]

yeah.... sktneer...

[Hazelbite]

Please can someone help me with a formula as follows;

I have multiple rows and multiple columns, the first row reads something like this

A B C D E F G H
Concentrates Minerals Concentrates Soya 21 10 11 2

And so on down the rows,
Column A volume is in Column E
Column B volume is in Column F and so on,

I would like to find the total of all concentrates in columns E-H, i.e E + G = 32 and post it in column I, and then the same for minerals and soya but put those results in column J & K.
This is a simpler example, I have 22 columns of text and then a further 22 columns of corresponding numeric.
Please help, Thank you very much

[sktneer]

Hi Hazelbite,
Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.