|
|
Can I use an IS function with Vlookup by
JJ in LA
I am trying to write a formula that says If the Vlookup returns NA, then plus
a particular cell, otherwise return the vlookup value. Can this be done.
I've...
|
|
2 |
79 |
|
|
|
|
1 |
85 |
|
|
|
August 9th, 2008 12:09 AM
by Max
|
3 |
85 |
|
|
Vlookup matching conditions by
Nancy Guillemette
Bonjour,
I have two large spreadsheets. I want to match the values in 4 cells (within
the same row) in one spreadsheet and search a second spreadsheet to...
|
August 9th, 2008 12:09 AM
by Max
|
3 |
103 |
|
|
Specify target cell by
New Ton
Hello. I am trying to get an output to a specific cell after change in any
cell in a range.
This code does what i want, except it offsets target next to...
|
|
8 |
91 |
|
|
|
|
2 |
84 |
|
|
|
|
4 |
76 |
|
|
Another Macro Question by
igotquestions
First of all, what would be a good book to get to help a new user with
learning how to create macros for Excel? The Dummies books don't seem to help
with the...
|
August 8th, 2008 10:56 PM
by Mike H
|
9 |
105 |
|
|
Drop-Down Lines by
FrazzledAdminAssist
I am trying to create a document with drop down boxes in excel. I go to the
Data menu, click Validation and then Settings. I go to the Allow box and
choose...
|
|
3 |
111 |
|
|
text to column by
Mike
I have a column that contains email addresses, a space, and then a street
address which has spaces between the street number and the street name. In
some...
|
|
6 |
107 |
|
|
Yesterday by
Loadmaster
I currently have a conditional formatting formula in Cell B2. Condition 1 is
this: Cell Value Is, between, =NOW()+1 and =NOW()+31, formatted yellow. This...
|
|
5 |
50 |
|
|
|
|
7 |
170 |
|
|
|
August 8th, 2008 09:20 PM
by Marcelo
|
1 |
93 |
|
|
Subrange by
Oscar
In range a (part of the column) I have series of values. I want to calculate
sum of positive and negative increments. Formula...
|
|
5 |
70 |
|
|
Macro help by
igotquestions
I am trying to create a macro that will add the dollar values in a specific
column. The problem I am having is that the number of vaules in that column
vary...
|
|
4 |
89 |
|
|
Conditional Formatting by
TaylorLeigh
I want the message "Inventory is below minimum" when a calculated field falls
below a certain number. Is it possible to have this message appear in the
cell...
|
|
2 |
64 |
|
|
functions do not calculate correctly by
petew812
I have used the financial functions lots in the past. Suddenly the simplest
of functions are not returning the correct answer. Even if I use the examples...
|
|
6 |
85 |
|
|
CONDITONAL SUM DATE RANGE ISSUE by
woody
Having an issue with suming using the Conditional sum wizard. At the bottom
is the formula.
Have 3 criteria, a specific code number (shown as V13 below ) and...
( 1 2)
|
|
10 |
156 |
|
|
Conditional formatting by
Trish
is it possible to preserve conditional formatting in a excel worksheet when
saving as a html?
|
|
1 |
80 |
|
|
Problem using average or sum formulas by
Miki
I'm facing problem while using sum or average formulas in same worksheet
when I try use it for more than 30 different cells. It calculates only 30 and
if I...
|
|
3 |
101 |