|
|
need sumproduct to return text values... by
jat
this is a follow up to my previously posted subject line: "vlookup (indirect,
or sumproduct) using three tabs"
i have a sumproduct working (sort of, but not...
|
April 18th, 2009 12:07 AM
by jat
|
2 |
198 |
|
|
|
April 17th, 2009 11:37 PM
by jat
|
3 |
131 |
|
|
Breaking down a cell to create a function by
Robert
I'm trying to create a flow graph by using current information on my
spreadsheet. I have a column of dates in this format 01/05/06. I trying to
find a...
|
|
5 |
111 |
|
|
Vlookup by
Dinesh
Hi,
I have three columns in Sheet1. COL A has DM#, COL B has CM# and COL C has
an amount.
Sheet2 has two columns. COL A has DM# and CM#. In COL B, I like to...
|
April 17th, 2009 10:41 PM
by Sheeloo
|
9 |
147 |
|
|
SUMIF based on several criteria. by
Mike
OK here is what I want to do. I have three different values that I want to
sum. I have several criteria that I have to consider when I sum them.
A B ...
|
April 17th, 2009 10:01 PM
by Mike
|
6 |
112 |
|
|
|
|
3 |
93 |
|
|
|
|
3 |
91 |
|
|
new macro to format worksheet by
mclovin
I'm trying to record a new macro to hide specific columns & rows. I went to
"record new macro" and went through the steps, but when I try to test out the...
|
April 17th, 2009 08:23 PM
by mclovin
|
2 |
72 |
|
|
|
April 17th, 2009 07:43 PM
by Crinks
|
2 |
72 |
|
|
Reference previous worksheet within VLOOKUP by
Alex Mackenzie
I have found several previous postings about this, but still cannot get my
function to work. If I put the name of the previous worksheet (e.g. March
09!...
|
|
2 |
75 |
|
|
|
April 17th, 2009 06:54 PM
by Luke M
|
1 |
68 |
|
|
|
April 17th, 2009 06:52 PM
by Billy B
|
3 |
69 |
|
|
|
|
4 |
85 |
|
|
If Statement Question by
Joe
=IF(D3=M3 and C3=M3,M3,"NO EXECUTION")
The above is yielding #NAME?
What is the proper syntax?
Everytime I have a need for this evaluation I stump myself...
|
April 17th, 2009 06:19 PM
by BIG D
|
4 |
61 |
|
|
Sumif linked to different workbook by
JLC1952
I have numerous sumif formulas in a workbook (see example below), and they
reference other workbooks. When I open the workbook with the formulas in it,
they...
|
|
1 |
74 |
|
|
use Hlookup to look up two or more values by
tywlam
How do I use hlookup to look up two or more values on the top rows and return
a value in the same column from a row specified? (hlookup allows to look up
one...
|
|
5 |
100 |
|
|
|
|
2 |
100 |
|
|
Data Validation by
AaronMcG
Hello all,
I am not an expert with excel. But i do use it very frequently.
And lately i've been setting up a project for my company to standardize...
|
April 17th, 2009 05:16 PM
by Kassie
|
1 |
63 |
|
|
Use Like in Vlookup by
ryguy7272
Here is my function:
=IF(ISNA(VLOOKUP(H12,'booked pivot'!G:H,2,FALSE)),0,VLOOKUP(H12,'booked
pivot'!G:H,2,FALSE))
I am trying to get Excel to evaluate this...
|
|
4 |
130 |
|
|
|
|
3 |
78 |