|
|
VLOOKUP IS ERROR by
PAL
Can someone advise why this formula returns a "0" and not a blank?
=IF(ISERROR(VLOOKUP(A2,Rawdata,13,FALSE)),"",VLOOKUP(A2,Rawdata,13,FALSE))
Thanks.
|
|
3 |
152 |
|
|
random number generator by
pat67
Hey is there a way to generate random numbers like you would for a
draft. In other words, i have numbers 1 through 10 and generate a
random order for those?
|
|
6 |
164 |
|
|
|
|
2 |
241 |
|
|
|
|
1 |
306 |
|
|
|
|
1 |
136 |
|
|
vba for color coding by
desperate-from-seattle
I love conditional formating but it allows only 3 different colour coding.
I need to set up:
1) 10 different colour coding (possibly using VBA, but dont know...
|
|
1 |
124 |
|
|
|
|
1 |
148 |
|
|
Removing disabled Macro by
Nadine
I had been playing with some macros in a book I have. I didn't think I had
saved any of them. Now when I open that workbook, I get a message that says...
|
May 7th, 2010 12:54 AM
by Nadine
|
6 |
191 |
|
|
|
|
3 |
126 |
|
|
Worksheet Functions by
Denrae
No matter how I enter a function, it displays as text in the cell and doesn't
perform the calculation. How can I enter a simple formula and have it display...
|
|
5 |
153 |
|
|
Auto-lock a cell once it's updated by
Oscar
Hi.
I have a shared workbook that is used by two processors. On column A I have
a drop down that allows the processors to select Yes or No. I would like the...
|
|
3 |
159 |
|
|
|
|
13 |
454 |
|
|
If Function Function by
aetejada
okay. So I am trying to workout a formula to compute a commision earning.
Basically, if X amount of new business is made, then X*Y (corresponding
Commision...
|
|
1 |
161 |
|
|
|
|
1 |
122 |
|
|
|
May 6th, 2010 11:18 PM
by dza7
|
2 |
243 |
|
|
|
May 6th, 2010 10:22 PM
by alagmy
|
0 |
107 |
|
|
|
|
2 |
101 |
|
|
Sum with 2 if's by
Nadine
I have a worksheet with the following data which are all results of formulas
in each cell. On another worksheet, I need to sum all the amounts in Col C
if...
|
|
1 |
123 |
|
|
Make all dates display 01 as the day by
LovingLife28
I have a list of dates with various numbers listed as the day (03/25/2009,
04/05/2010, etc.) I need a formula to change all of the dates to display 01
as...
|
|
2 |
205 |
|
|
Latest Purchase Price by
Curtis[_6_]
In the source sheet
COL AB = recent cost
COL W = latest purchase date (format mm/dd/yyyy)
COL A = Part number
I need to identify the latest cost of each...
|
|
3 |
164 |