]Hello to all,
ask help for a formula:
I attach the file.
Please Login or Register to view this content.
max_max
-----------------------------------------------------------------------------------------------------------------------------
Ciao a tutti,
chiedo un aiuto per una formula:
allego il file.Please Login or Register to view this content.
max_max
[ATTACH]288202[/ATTACH
E4:
=INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))
and copy down
formula%20english(1).xls
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Perfect daffodil11!
Thank you,
a greeting.
max_max
-----------------------
Perfetto daffodil11!
Grazie,
un saluto.
max_max
Non c’è di che
Last edited by daffodil11; 01-07-2014 at 04:11 PM.
Hello,
the formula:
=INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))
works fine.
You can not display " 0 " or " #N/A " if there are missing values?
Thank you,
max_max
---------------------------------------------------------------------------
Ciao,
la formula:
=INDICE(A4:C4;CONFRONTA(E$2;A$3:C$3;0))
funziona bene.
E' possibile non visuallizzare " 0" oppure " #N/D " se mancano dei valori?
Grazie,
max_max
Last edited by max_max; 01-08-2014 at 03:22 PM.
It's your choice.
=IFERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)),0)
or
=IFERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)),"N/A")
or
=IFERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)),"")
Hello daffodil11.
With the new formulas continues to visulizzarsi #N/A or 0 if there are missing values.
max_max
---------------------------------------------------------------------------------------------
Ciao daffodil11.
Con le nuove formule continua a visulizzarsi #N/D oppure 0 se mancano dei valori.
max_max
Oh, I thought that was what you wanted.
Do you want it to show nothing or blank?
=IFERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)),"")
This makes "N/A" into " "
O.K. daffidil11
the formula:
= IFERROR (INDEX (A4: C4, MATCH (E $ 2, $ 3: C $ 3,0)), "")
shows nothing or empty.
But if the range A4: C4 is blank value = 0
0 must be blank/empty as #N/A
max_max
-----------------------------------------------------------------
O.K. daffidil11
la formula:
=SE.ERRORE(INDICE(A4:C4;CONFRONTA(E$ 2; $ 3: $ C 3;0)); "")
mostra nulla o vuoto.
Ma se il range A4:C4 è blank valore = 0
0 deve essere blank/vuoto come #N/D
max_max
Last edited by max_max; 01-08-2014 at 05:24 PM.
I think I understand.
= IFERROR(IF(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))=0,"#N/A",INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))), "")
If A4:C4 = blank, you need output #N/A.
This should do it.
Hello daffodil11,
the formula is o.k..
It runs on excel 2000?
Thank you,
max_max
------------------------
Ciao daffodil11,
la formula è o.k..
Funziona su excel 2000?
Grazie,
max_max
For 2000:
=IF(ISERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))),"",IF(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))=0,"#N/A",INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)))
Hello daffodil11 is perfect!
=IF(ISERROR(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))),"",IF(INDEX(A4:C4,MATCH(E$2,A$3:C$3,0))=0,"#N/A",INDEX(A4:C4,MATCH(E$2,A$3:C$3,0)))
Thank you very much.
Greetings from Italy,
max_max
--------------------------------
Ciao daffodil11 è perfetto!
=SE(VAL.ERRORE(INDICE(A4:C4;CONFRONTA(E$2;A$3:C$3;0)));"";SE(INDICE(A4:C4;CONFRONTA(E$2;A$3:C$3;0))=0;"#N/D";INDICE(A4:C4;CONFRONTA(E$2;A$3:C$3;0)))
Grazie mille.
Un saluto dall'Italia,
max_max
Glad I could help, it was my pleasure.
Feel free to Mark Thread as Solved under Thread Tools
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks