I have 2 worksheets.
When I type 150 in worksheet #1, I want excell to lookup the value from
worksheet #2 that correspond to 150 (and return those values in Worksheet
#1). Since there is no 150 (in worksheet #2), I want it to give the

I got column A and B
Column A   Column B
banana        red
orange        green

Hi. can anyone help me solve this formula on excel..
=IF(PlanA=0,PlanB,PlanD)
Thanks

I have a small table (C4:G85)
Col. C is part numbers
D-E-F are quantities
Col. G is total quantity

Hi. can anyone help me solve this formula on excel..
=IF(PlanA=0,PlanB,PlanD)
Thanks

I was looking for some ideas on how to add up cells that contain time
vaulues. I work with peoples shifts and hours and I want to be able to add up
in any given day, how many 7-330 shifts, 8-430...shifts that I have on each
day. How can I get Excel to add down each column ...

A friend of mine has a problem in Excel 97. I had the same problem a
few years ago. When you open a spreadsheet you can see the Excel
application menus and toolbars at the top of the screen and the status
bar at the bottom. However the space between where the worksheets

I do this all the time in the header or footer wherever needed by
using the "&[Tab]" feature available; however, is there some coding
that we can put into a cell that will do the same anywhere on the body
of the sheet itself?

Ok got a weird Q.
Is there any way to change the formatting on a column when you do a
filter on it? I've been using the auto filter function as there is
fairly easy values to filter on and was just wondering if you filter a

I have a long list of product codes e.g. 230956743, 485048675. But i
want to put a zero in front of each one e.g. 0230956743, 0485048675. Is
there a quick way of doing this.
Obviously the column will have to be formatted as text because

I would like to create a spread sheet for book keeping purposes at my church.
I am responsible for counting large sums of money and I would like to plug
in numbers and get a running total

Any idea of a way to use the last portoin of this formula to count zeros
instead of treating all blank cells as zeros?  I am trying to bring back a
combination that would consist of programs that have an OPEN status and have
a type of NPD at a Max Gate Status of 0 = 2.  My data ...

I'm tring to calculate todays date and subtract a number of working days
and have the answer in date format.
A1 =     02 November 05            
B1 =     5                                            

I would like to teach excel by example ? would you pls let me find best
examples in excel for newuser and expert
best

I did up some titles in mixed cases then realized that they printed
out better in all upper case.  Can we select all and change globally
with a keystroke as in Word, etc.?  I ended up doing these all
manually as I couldn't find anything in the pulldowns re this or in