|
|
Vlookup inside a formula by
willemeulen[_4_]
Is it possible to use a vlookup funciont inside a formula?
:Bgr
--
willemeulen
Blink1 *Willem van der Meulen* BSc Soil & Water Eng...
|
May 14th, 2009 10:33 AM
by Mike H
|
1 |
76 |
|
|
|
|
2 |
78 |
|
|
|
|
2 |
73 |
|
|
Copy format by
LiAD
Hi,
I have several spreadsheets where I import data using macros into a series
of tables. Several operations are then performed on the data. The new...
|
May 14th, 2009 08:42 AM
by LiAD
|
4 |
67 |
|
|
Round to .05 or .09 by
Bruce
How can I round prices to the nearest 0.05 or 0.09?
Eg 1
5.01 to 4.99
Eg 2
4.44 to 4.45
Regards,
Bruce
|
|
4 |
117 |
|
|
GL Codes by
Jonny54321
I have a 2008 trial balance (on its own worksheet) and in Column A consists
of all the GL codes.
In my 2007 trial balance (on its own worksheet), I also have...
|
|
1 |
84 |
|
|
lookup formula unexpected results by
David Ryan[_3_]
Hi Folks hope someone can help. One of you guys usually can. So thanks in
advance
The following formula provides unexpected results.
=IF(ISERROR(LOOKUP('Hotel...
|
|
1 |
133 |
|
|
lookup formula unexpected results by
David Ryan[_3_]
Hi Folks hope someone can help. One of you guys usually can. So thanks in
advance
The following formula provides unexpected results.
=IF(ISERROR(LOOKUP('Hotel...
|
|
3 |
131 |
|
|
Eliminating Blank rows by
Lversteeg
I am hoping someone can help me!!!!
I have on one sheet a product selector for my sales team. I have added a
column where they can put an "x" into if...
|
|
3 |
141 |
|
|
Reverse SumProduct function by
ajkajkajk
Does anyone know how to create an array that multiplies 2 numbers together
but selecting the first number in one array multiplied by the last in the
other...
|
May 14th, 2009 02:35 AM
by Lori
|
9 |
154 |
|
|
Returning a value if false by
James W
I have a spreadsheet that I am working on. It has a row that has either an X
or an O for about 30 days. I am trying to write a formula that will review
that...
|
|
2 |
91 |
|
|
mortgage payment calculation by
kacky
What is the excel formula to calculate a mortgage payment? also is there a
formula which can solve the amount of principal paid in a defined period? for...
|
|
6 |
153 |
|
|
|
|
4 |
88 |
|
|
EXCEL FIND A SPECIFIC TOTAL by
KUNA
Is there a formula or look up function within excel that will do the following:
Locate within a range of cells the cells that when summed together equal a...
|
May 14th, 2009 01:45 AM
by Lori
|
4 |
96 |
|
|
|
|
3 |
66 |
|
|
|
|
11 |
247 |
|
|
|
|
1 |
123 |
|
|
Summing Values/Outputs of IF formulae by
shadesoflife
Would anyone be able to advise me how to go about summing the values/outputs
that result from the use of a IF formula?
Background - I used a IF formula to...
( 1 2)
|
|
10 |
164 |
|
|
Evaluate based on Actual Month by
RJJ
I am (with the help of this forum) successfully pulling data from a range of
cells. The range I set up was data for the month of May. What should I
preceed a...
|
|
7 |
115 |
|
|
Round formula by
GIDRA
I have this formula (below). Is there an easier way to do it...
|
|
3 |
124 |