|
|
Excel drag down formula not working good.. by
zoola ander
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
0 |
72 |
|
|
Excel drag down formula not working good.. by
zoola ander
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
1 |
68 |
|
|
vba excel macro question...ranges by
zoola
Hello,
I have been asked by a friend to help with vb/excel, however i have not
touched vb in my life. I have a background in c/c++, so if someone could
point...
|
|
3 |
144 |
|
|
Excel drag down formula not working good.. by
zoola
hi,
i have a formula
=IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0)))
when i drag...
|
|
1 |
74 |
|
|
|
|
1 |
92 |
|
|
Special today Date challenge question by
ZONNET
What I want is have a today function eg in cell A1.
based upon entering any text in for eg b2, puts me the julian dat in cell
A2, So far, so good, I got that...
|
|
1 |
397 |
|
|
Which function do I use? by
Zong
Workbook with 2 spreadsheets. I need to look up a part number in one column
and have it give me the value in another column on the same row.
PS# ...
|
February 22nd, 2009 11:20 PM
by T. Valko
|
7 |
77 |
|
|
Excel comments by
zonegrise
Hi,
Is possible to change the default font type in Excel comments? (not just the
size but the font itself)
|
|
1 |
223 |
|
|
|
|
1 |
63 |
|
|
|
November 29th, 2005 03:36 PM
by zomex
|
5 |
83 |
|
|
|
|
1 |
71 |
|
|
how to get the middle name by
zomex
how can i get the middle name of "fazain iqbal khan"... i can get the last
name by =(a2,len(a2)-search("#", substitute(a2&" "," ","#",2)))... and...
|
|
2 |
64 |
|
|
help needed by
zomex
eg. "mick jagger bush" "muhammad ali clay" "ayesha bin batool"
suppose that these r the names and i want formula that would be generic to
all, such that it...
|
|
5 |
69 |
|
|
help by
zomex
guys how can i generate a formula that would lead to even number letters
like"bush" "clay" "boss" "sale" "cout" to have capital letter of first and
third...
|
January 4th, 2006 05:53 AM
by JulieD
|
1 |
72 |
|
|
help by
zomex
if names r given to me which contain even letters like "bush" "boss" clay"
"wali" "walou".... how can i generate a formula that would lead to the first
and...
|
|
1 |
56 |
|
|
|
|
1 |
116 |
|
|
vlookup by
zolabus
Hi
i have two column with similar but not equal values
haw can i use vlookup to see wich elements of the B column are not in the A
column?
Thanks a lot
|
August 22nd, 2007 02:46 PM
by Max
|
1 |
51 |
|
|
filter by
zolabus
Hi and sorry for my english
when i use the authomatic filter i need that the results are numbered in a
near column.
Is it possible?
|
|
1 |
47 |
|
|
SHOW AUDIT ARROWS by
ZOEY GREENE
how can I show viewers the audit trail arrows in a saved filed? say, when I
email an excel file, I want the recipients see the audit trail arrows when
they...
|
|
0 |
79 |
|
|
|
|
7 |
75 |