|
IF & Vlookup Assistance
Evening Chuck
I tried your suggestion
=IF(ISNA(VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE)),"Invalid
Number"&","&VLOOKUP(LEFT(A9,4),$A$2:$C$20882,2,FALSE),VLOOKUP(A9,'Schedule'!$B$2:$C$20882,2,FALSE))
I got a messg #N/A. I tried it in a smaller size worksheet.
example
Sheet 1 is where I am doing the Vlookup from. Sheet 1 has 3 column with
data col A contain both 8 digits and 4 d...
|
3 |
08.08.2006 17:04:12 |
|
|
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT
I have a list of invoice dates where the day is first and the month is
second, and the year is third. I need to convert to the US format of month
first, day second and year third. Any suggestions are most appreciated.
Thanks....
|
9 |
08.08.2006 16:48:02 |
|
|
Sorting ( what happened)
Excel 2003
Windows XP
I was sorting a list that read:
Store Item Price
I'm not sure what I did but when I look back it was in this order:
Price Item Store
Now I cannot get the "Store" column back without physically moving it.
...
|
3 |
08.08.2006 10:00:54 |
|
|
How can I create slanted headers?
Hello,
At work today I was asked to create a spread sheet with products and
they want the colums on the top to say the name of the product in a
slanted lined format. I am not sure what this is called and I am not
sure how to explain it with out showing what I mean.
But instead if striaght up and down lines on the top the need to be
slanted on an angel when you type the text in the texts type...
|
16 |
08.08.2006 05:49:42 |
|
|
excel copy cells to word template
I have a large workbook and I want to copy cells from one sheet called
Menu to a specific word template called PDC_MCC_IR.dot and save the
word template as a word document. I have a bit of code that can open a
word document and past information from cells in the word document but
I need help for the rest. Can anyone help me. Here is the code that I
already have.
Sub Excel_to_Word()
Dim...
|
3 |
08.08.2006 03:30:52 |
|
|
How do I stop the scrolling?
Hello,
I am new to this site, I am hoping someone can help me with a problem I am
having.
I have been using excel for a few years now but only basic stuff. Tonight I
did somthing that changed some setting of some kinds and I dont know what I
did or how to get it back to the way it was.
The way it was,,, when I wanted to move from cell to cell I used the arrow
keys on my keyboard....
|
3 |
08.08.2006 03:08:43 |
|
|
Questions on Auto Filter
Hi,
(1) In the "top 10" dialogue box, there is a choice between "items" and
"percent." I understand "items" but not "percent" which may return more or
less rows when chosen.
(2) On the bottom left of the worksheet, it shows "xx of xxx records found"
for one worksheet while it shows "filter mode" for another after a
**similar** process. I wonder why and how can I make the latter works...
|
4 |
08.08.2006 01:58:32 |
|
|
How do I format a notpad document into Excel?
I've downloaded a document from Notepad to Excel. How can I format it to
different columns, or utilize the way it is now and it would print out each
line without cutting off portions of each line? ...
|
2 |
08.08.2006 01:01:54 |
|
|
I need an Excel Spreadsheet for Cafeteria Plan Accounting.
I am using Office XP. I have been asked to track employee receipts for a
small daycare/elementary school. This is our first year to implement this
feature for about 30 teachers/employees. Each person will be allowed $500
for the year. I must record their receipts and be able to give them a
running balance at any time. I need to show spending catagories. Thank you
for your help....
|
2 |
07.08.2006 22:25:31 |
|
|
link cells
How do I get the info in a cell on one worksheet to update the same info in a
cell on another work sheet?...
|
2 |
07.08.2006 21:26:01 |
|
|
How do I delete chart superimposed on Excel document?
Created Excel document. Print preview did not show gridlines. In attempting
to get gridlines, somehow got into charts. A chart was created and is
superimposed on original document. How do I get rid of the chart? How do I
get gridlines on to original document?...
|
3 |
07.08.2006 20:01:39 |
|
|
I'm a salaried employee, ?how to calculate actual rate of pay
I am on salary (weekly) but always work alot more than 40 hrs per week.
How can I make a spreadsheet that will calculate my rate of pay on a weekly
basis, by me typing in the hours worked per week(ex; 40 reg + 20 overtime)
Please Help,
Thanks in advance....
|
21 |
07.08.2006 18:00:50 |
|
|
Need result not formula in cells
Hi everyone! Using E02 on XP. Having fits over this, can't figure out what
is happening. Have a spreadsheet and want all of the records in Column AG to
'read' the contract number contained in cell G1. First record is in row 4,
so in AG4 I typed =G1. Worked fine. Did a Fill;Down, realized I wanted =G1
in each cell so I tried to key that into AG5 and all I get is the formula
(=G1) ra...
|
5 |
07.08.2006 12:57:02 |
|
|
option buttons or check boxes
I am fairly new to VBA and trying to learn on the fly. I have a spreadsheet
with 4 sheets, each with its own name. I want to create 4 check boxes or
option buttons on the first sheet. I have print button. I want to have it
so when you check a box and hit the print button, only that sheet will print.
If you check all 4, all 4 print, etc.
Can anyone help?
Thanks!
--
Message pos...
|
3 |
07.08.2006 11:55:08 |
|
|
Opening Protected EXCEL worksheets to update linked data
I have the following code that should open all EXCEL workbooks in a
specified path, and unprotoect any password-protected worksheets to allow
for Link Updates, then close the workbook after password protecting it. For
some reason, I can't get this code to work -- any ideas?
================================
I put the following code in a general module of a sheet1 of a workbook
sub Updat...
|
10 |
07.08.2006 09:51:15 |
|
|
Removing A Vertical Page Break That Won't Go!
Hi. If anyone at all can help me out, that would be great. I am
trying to print something that can fit onto one page vertically, but
there is a vertical page break which will not remove itself no matter
how I try to do it. I've already done the obvious by using the Office
Assistant and following the instructions, which are to click in the
right of the cell column with the page break there, ...
|
6 |
07.08.2006 06:33:22 |
|
|
How do I correct a range 'reference'?
Using Excel XP.
=====================
I've had a frustrating time with DSUM on a workbook I'm building from
someone else's model - I keep getting #VALUE! errors. After lots of looking
"underneath the hood" I think I see the problem, but don't know how to fix
it.
One of the formulas is: =DSUM(Revenue,'Revenue Projects'!$D$3,B1:B3)
The problem comes up with "Revenue". When I use the...
|
4 |
06.08.2006 23:53:01 |
|
|
Adding times
Hi there,
Anyone able to tell me how to add times minutes and seconds so that the
answer will show hours minutes and seconds. Any hints on the best way to
format the cells to show times would be great.
Thank you!
--
Bobby...
|
4 |
06.08.2006 22:09:01 |
|
|
probably an easy one but... (using SUMPRODUCT?)
Hi guys, looks like a nice forum you have here.
I've started making a record of all the purchases every month that my
kitchen makes. I've set every supplier to an ID code (001,002,003 etc
etc) and i record this code in the same row as each purchase amount. So
for a month, i have a list of purchases, with totals excluding vat, vat
and then a total inclusive of vat. At the end of the month i can...
|
6 |
06.08.2006 15:45:01 |
|
|
Date Fill
I would like to create a spreadsheet where if you input date as Jan06 in
cell
A1, subsequent cells B1 C1 D1 etc automatically fill as
feb06,mar06,apr06 -
Can anyone help
--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31616
View this thread: http://www.excelforum.com/showthre...
|
8 |
06.08.2006 06:20:46 |
|
|
In addicting across columns, every sixth column, I loose .01
Aftre changing time into decimals, whrn I add up the numbers in each column,
I loose .01 in the third column, then the same in every sixth column....
|
2 |
06.08.2006 02:47:01 |
|
|
Question on Payment function.
When using the payment function in Excel, I notice that the result of
my formula is always a negative number. I have seen two different ways
to crrect this:
One is to put a (-) in the Pv (Present Value) field, before clicking
on the cell that holds the present value.
The other is to put a (-) in front of the equation, like this: = -
PMT(A2/12,A3,A1).
They both give me the desired result. ...
|
5 |
06.08.2006 00:32:28 |
|
|
my excel files are being opened in Word and are unreadable Why?
Files are being saved in the correct format and can be opened normally from
the recent files section of the File Menu in excel. The copmputer tried to
open them in Word from My Computer...
|
3 |
05.08.2006 16:49:07 |
|
|
Adding payroll stubs payroll calculator
I am trying to add more payroll stubs on my payroll calculator. I have 5
employees and it only gives me stubs for four of them. I need to be able to
add more with out having to set it up myself, as I don't know how....
|
3 |
05.08.2006 16:37:38 |
|
|
How to calculate pass/fail percentages entered on a spreadsheet?
I am trying to set up a spreadsheet with driving test results including one
column to say pass one to say fail and calculate the percentage of each on a
monthly basis. I can enter the info but don't know how to calculate the
percentages...
|
3 |
05.08.2006 16:29:04 |