Warning

 

Close

Confirm Action

Are you sure you wish to do this?

Confirm Cancel
Member Login

Posted: 3/17/2011 8:14:59 AM EST
[Last Edit: 3/17/2011 10:00:58 AM EST by Global_Cooling]
I need help with a spreadsheet. I have a file I can provide. I'm sure it's quite simple.

Basically I need to compare the value of a cell to a list of other cells then return the value of the column.

Example:
I want to type in the day and have it return values for that day from another worksheet. I.E. If you type in Monday it will return Monday's values, Tues.....etc...


Thanks in advance.

P.S. If I can get this by tonight I'd appreciate it!

UPDATE:

Here is the formula I used:

=INDEX('Par Sheet'!$A$2:$H$52, MATCH("Grilled Veggies",'Par Sheet'!$A$2:$A$52,), MATCH('Input Sheet'!A2,'Par Sheet'!$A$2:$H$2,))

Link Posted: 3/17/2011 8:40:38 AM EST
There's no simple way to do this without a VBA script.

Have you ever written VBA scripts, or are you fishing for someone to write you one?

What's the purpose of this little project? Is it for a class?
Link Posted: 3/17/2011 9:11:26 AM EST

It's for work.

Would it be easier if the information were on 1 sheet?

I'm a restaurant manager and basically it is a prep list with different par levels for each day. I want to type in a day of the week and have the par levels. That way I can make the prep lists.

Top Top